oracle-apps-tech.blogspot.com

Oracle Applications - Gaurav Sehgal

Oracle Applications - Gaurav Sehgal. Wednesday, March 11, 2009. Oracle Advanced Benefit (OAB) Queries. I will try to give the basic queries without joining with plans or options or programs. So that everyone can understand the basic underlying conditions. Later on you can add all plan and program joins to add to the reports. Ben prtt enrt rslt f. P business group id. Enrt cvg strt dt. Enrt cvg thru dt. Enrt cvg thru dt. Prtt enrt rslt stat cd. You can use the following query for rates. Ben prtt rt val.

http://oracle-apps-tech.blogspot.com/

OVERVIEW OF oracle-apps-tech.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

9

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR ORACLE-APPS-TECH.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

December

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Saturday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 3.4 out of 5 with 9 reviews

5 star

3

4 star

2

3 star

2

2 star

0

1 star

2

Hey there! Start your review of oracle-apps-tech.blogspot.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

0.3 seconds

FAVICON PREVIEW

16x16
32x32

CONTACTS AT ORACLE-APPS-TECH.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

9

SSL

EXTERNAL LINKS

0

SITE IP

172.217.11.33

LOAD TIME

0.297 sec

SCORE

6.2

PAGE TITLE

Oracle Applications - Gaurav Sehgal | oracle-apps-tech.blogspot.com Reviews

<META> DESCRIPTION

Oracle Applications - Gaurav Sehgal. Wednesday, March 11, 2009. Oracle Advanced Benefit (OAB) Queries. I will try to give the basic queries without joining with plans or options or programs. So that everyone can understand the basic underlying conditions. Later on you can add all plan and program joins to add to the reports. Ben prtt enrt rslt f. P business group id. Enrt cvg strt dt. Enrt cvg thru dt. Enrt cvg thru dt. Prtt enrt rslt stat cd. You can use the following query for rates. Ben prtt rt val.

<META> KEYWORDS

1 1 enrollment results

2 select

3 from

4 where

5 business group id

6 p effective date

7 between

8 effective end date

9 null

10 sspndd flag

CONTENT

Page content here

KEYWORDS ON PAGE

1 enrollment results,select,from,where,business group id,p effective date,between,effective end date,null,sspndd flag,person id,p person id,2 enrollment rates,3 eligibility results,4 enrolled dependents,dpnt,exists,voidd,bckdt,cvg strt dt,cvg thru dt,plan

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

Oracle Applications - Gaurav Sehgal | oracle-apps-tech.blogspot.com Reviews

https://oracle-apps-tech.blogspot.com

Oracle Applications - Gaurav Sehgal. Wednesday, March 11, 2009. Oracle Advanced Benefit (OAB) Queries. I will try to give the basic queries without joining with plans or options or programs. So that everyone can understand the basic underlying conditions. Later on you can add all plan and program joins to add to the reports. Ben prtt enrt rslt f. P business group id. Enrt cvg strt dt. Enrt cvg thru dt. Enrt cvg thru dt. Prtt enrt rslt stat cd. You can use the following query for rates. Ben prtt rt val.

INTERNAL PAGES

oracle-apps-tech.blogspot.com

1

Oracle Applications - Gaurav Sehgal: September 2008

http://oracle-apps-tech.blogspot.com/2008_09_01_archive.html

Oracle Applications - Gaurav Sehgal. Tuesday, September 30, 2008. Finding Patch Set Level. SELECT * FROM (. SELECT '(Patch: ' bug number ') applied ' LAST UPDATE DATE PFbugDate. WHERE BUG NUMBER IN (. 2968701', - F. 3116666', - G. 3233333', - H. 3127777', - I = 11.5.10 base. 3333633', - J. 3500000', - K. 3800000', - L. ORDER BY LAST UPDATE DATE desc. WHERE ROWNUM = 1;. Find the key flex field structure. SELECT id flex structure code structure code,. DECODE (dynamic inserts allowed flag,. NULL, 'NULL',.

2

Oracle Applications - Gaurav Sehgal: April 2008

http://oracle-apps-tech.blogspot.com/2008_04_01_archive.html

Oracle Applications - Gaurav Sehgal. Tuesday, April 15, 2008. Steps to Setup Basic Bonus Plan. Steps to Setup Basic ICD Plan for Bonus. A) Create a plan type of type Individual Compensation Distribution (Total Compensation = Programs and Plans = Plan Types). B) Create a Plan using the above plan type and following information (Total Compensation = Programs and Plans = Plans). Usage: May not be in program. Allow Unrestricted = Checked. Enroll in Plan and Option = Checked. Coverage Start Date= Event. Go to...

3

Oracle Applications - Gaurav Sehgal: Basic Definition of Oracle Advanced Benefits (OAB)Terminology

http://oracle-apps-tech.blogspot.com/2009/01/basic-definition-of-oracle-advanced.html

Oracle Applications - Gaurav Sehgal. Wednesday, January 21, 2009. Basic Definition of Oracle Advanced Benefits (OAB)Terminology. I have received lot of questions regarding Benefits module. So I thought I will go through some basics terminology used in Benefits following with some details and queries. Once we Process a potential Life event it is called Person in Life Event. Is a group of plans that have similar properties, like when to enroll, how to enroll etc. For each Program or Plan we define Enrollme...

4

Oracle Applications - Gaurav Sehgal: January 2009

http://oracle-apps-tech.blogspot.com/2009_01_01_archive.html

Oracle Applications - Gaurav Sehgal. Wednesday, January 21, 2009. Basic Definition of Oracle Advanced Benefits (OAB)Terminology. I have received lot of questions regarding Benefits module. So I thought I will go through some basics terminology used in Benefits following with some details and queries. Once we Process a potential Life event it is called Person in Life Event. Is a group of plans that have similar properties, like when to enroll, how to enroll etc. For each Program or Plan we define Enrollme...

5

Oracle Applications - Gaurav Sehgal: March 2009

http://oracle-apps-tech.blogspot.com/2009_03_01_archive.html

Oracle Applications - Gaurav Sehgal. Wednesday, March 11, 2009. Oracle Advanced Benefit (OAB) Queries. I will try to give the basic queries without joining with plans or options or programs. So that everyone can understand the basic underlying conditions. Later on you can add all plan and program joins to add to the reports. Ben prtt enrt rslt f. P business group id. Enrt cvg strt dt. Enrt cvg thru dt. Enrt cvg thru dt. Prtt enrt rslt stat cd. You can use the following query for rates. Ben prtt rt val.

UPGRADE TO PREMIUM TO VIEW 4 MORE

TOTAL PAGES IN THIS WEBSITE

9

OTHER SITES

oracle-apps-dba.com

Default Web Site Page

If you are the owner of this website, please contact your hosting provider: webmaster@oracle-apps-dba.com. It is possible you have reached this page because:. The IP address has changed. The IP address for this domain may have changed recently. Check your DNS settings to verify that the domain is set up correctly. It may take 8-24 hours for DNS changes to propagate. It may be possible to restore access to this site by following these instructions. For clearing your dns cache.

oracle-apps-fusion.blogspot.com

Oracle Apps and fusion articles

Oracle Apps and fusion articles. The blog has some useful information for Oracle Applications/fusion developers and consultants. Tuesday, September 20, 2011. Comparing OAF and ADF. We will compare OAF and ADF in the post. Similarities between OAF and ADF. Let us see the similarities between them. This will make OAF guys easier to understand ADF. The Model layer (considering MVC) of ADF is quite similar to ADF. It has same concepts on EO, VO, VL and AM. Differences between ADF and OAF. Position - per posi...

oracle-apps-presales.blogspot.com

Learnings of a Oracle Presales Consultant

Learnings of a Oracle Presales Consultant. Wednesday, August 25, 2010. Business Case: Re implement or Upgrade Oracle Applications. Business case: Upgrade Vs Re-implementation of Oracle Applications. Posted by Oracle Applications Presales Consultants Blog. Tuesday, August 24, 2010. SAP Vs Oracle Applications Comparison. Couple of Salient points of Oracle Applications. Which we usually emphasize in our presentations includes. Multi org Access Control). Oracle is better in Project Management Modules. Oracle...

oracle-apps-professionals-online.com

New Page

Welcome to Oracle Apps Professionals Online! This is a Social Network. Where Oracle Apps Professionals, such as yourself, can connect with peers in your field, to share knowledge, content, information, job openings, experience, a get-together at lunch anything! Gather all Your Friends and Colleagues. Once you complete the super simple 4 field registration process, and create a Profile for your self, you can start inviting your friends, to the network. You can embed Media content in your messages.

oracle-apps-support.blogspot.com

oracle-apps-support

Friday, April 1, 2011. HRMS suite of Oracle applications is useful in managing the employees of an enterprise. Some of the major featues are capturing employee information, day to day employee management, time entry, performance capture and appraisals, capturing compensation information and managing payroll. Important modules within HRMS are. 8226; HR (Person, Assignment, work structures). 8226; Payroll (setting up compensation for employees, running payroll, paying employees). Person form captures the p...

oracle-apps-tech.blogspot.com

Oracle Applications - Gaurav Sehgal

Oracle Applications - Gaurav Sehgal. Wednesday, March 11, 2009. Oracle Advanced Benefit (OAB) Queries. I will try to give the basic queries without joining with plans or options or programs. So that everyone can understand the basic underlying conditions. Later on you can add all plan and program joins to add to the reports. Ben prtt enrt rslt f. P business group id. Enrt cvg strt dt. Enrt cvg thru dt. Enrt cvg thru dt. Prtt enrt rslt stat cd. You can use the following query for rates. Ben prtt rt val.

oracle-apps-technical.blogspot.com

Oracle Apps Technical

Hey Friends, The basic idea for creating this blog is to have a Technical information about Oracle Applications. To have one such place where you will have a TECHNO-FUNCTIONAL knowledge of Oracle Applications. Monday, June 30, 2008. DATA FLOW IN ORDER TO CASH. TECHNICAL DATA FLOW IN ORDER TO CASH. Received from customer in Order Management (Sales Order). OE ORDER HEADERS ALL. Select header id,. Transactional curr code,. Shipping method code,. Ship from org id,. Ship to org id,. Flow status code,. Where s...

oracle-apps-training-online.com

Oracle Apps Training and Tutorials Available Online for All Practitioners

If Only Learning Oracle Apps R12 were Quick. and Easy! Has this thought ever crossed your mind? Welcome to Oracle Apps Training Online! Before you begin to wonder if this site is worth your time, picture this. Try This FREE Download First! The Wait is Over! The Mega Video has been Released! Can We Have a Trial Version. FREE. for this Start-to-End VIDEO? Sure, that's what we do at this site! We want you to explore and review all hosted content! This TRIAL version is available as a FREE Download . You hav...

oracle-apps.com

Online Trainings

Email Us : ramireddyg.erp@gmail.com. Oracle E-Business Suite Training will. Help your company manage the complexities of global business environments. Show you how this application provides a single, global basis of information to align departments. Enable your organization to reduce costs and increase performance. E-Business Suite Supply Chain Management.

oracle-appss.blogspot.com

100+ Topics Covered in my Blog | Home

Oracle Apps- Technical consultant. View my complete profile. 100 Topics Covered in my Blog. Technical Terms in Oracle Apps explained through real time example. Base tables and uses from different modules. How to submit a concurrent program from pl sql. How to Register a Concurrent Program with a Responsibility. Script to asign Concurrent Program to a Request group. Script to set org context in Oracle apps R12 and 11i. Script to remove end date from responsibilities assigned to user. Script to Check Curre...