eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GB_ENROLL_PENSION dependencies on PAY_INPUT_VALUES_F

Line 6: G_QUALIFYING_SCHEME_NAME CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Qualifying Scheme Name';

2: /* $Header: pygbpaep.pkh 120.16.12020000.3 2013/03/28 10:22:13 rsadhana noship $ */
3: AUTHID CURRENT_USER AS
4: G_END_OF_TIME DATE :=fnd_date.canonical_to_date('4712/12/31 00:00:00');
5: G_ELEMENT_NAME CONSTANT PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE := 'Pensions Information';
6: G_QUALIFYING_SCHEME_NAME CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Qualifying Scheme Name';
7: G_AGG_EARNINGS_PENSIONS CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Aggregate Earnings';
8: G_AUTO_ENROLLMENT_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Auto Enrollment Date';
9: G_QUALIFYING_PS_EXISTS CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Qualifying scheme exists';
10: G_POSTPONEMENT_TYPE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Postponement Type';

Line 7: G_AGG_EARNINGS_PENSIONS CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Aggregate Earnings';

3: AUTHID CURRENT_USER AS
4: G_END_OF_TIME DATE :=fnd_date.canonical_to_date('4712/12/31 00:00:00');
5: G_ELEMENT_NAME CONSTANT PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE := 'Pensions Information';
6: G_QUALIFYING_SCHEME_NAME CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Qualifying Scheme Name';
7: G_AGG_EARNINGS_PENSIONS CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Aggregate Earnings';
8: G_AUTO_ENROLLMENT_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Auto Enrollment Date';
9: G_QUALIFYING_PS_EXISTS CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Qualifying scheme exists';
10: G_POSTPONEMENT_TYPE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Postponement Type';
11: G_POSTPONEMENT_END_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Postponement End Date';

Line 8: G_AUTO_ENROLLMENT_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Auto Enrollment Date';

4: G_END_OF_TIME DATE :=fnd_date.canonical_to_date('4712/12/31 00:00:00');
5: G_ELEMENT_NAME CONSTANT PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE := 'Pensions Information';
6: G_QUALIFYING_SCHEME_NAME CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Qualifying Scheme Name';
7: G_AGG_EARNINGS_PENSIONS CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Aggregate Earnings';
8: G_AUTO_ENROLLMENT_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Auto Enrollment Date';
9: G_QUALIFYING_PS_EXISTS CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Qualifying scheme exists';
10: G_POSTPONEMENT_TYPE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Postponement Type';
11: G_POSTPONEMENT_END_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Postponement End Date';
12: G_EMPLOYEE_CLASS CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Pension Classification';

Line 9: G_QUALIFYING_PS_EXISTS CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Qualifying scheme exists';

5: G_ELEMENT_NAME CONSTANT PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE := 'Pensions Information';
6: G_QUALIFYING_SCHEME_NAME CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Qualifying Scheme Name';
7: G_AGG_EARNINGS_PENSIONS CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Aggregate Earnings';
8: G_AUTO_ENROLLMENT_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Auto Enrollment Date';
9: G_QUALIFYING_PS_EXISTS CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Qualifying scheme exists';
10: G_POSTPONEMENT_TYPE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Postponement Type';
11: G_POSTPONEMENT_END_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Postponement End Date';
12: G_EMPLOYEE_CLASS CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Pension Classification';
13: G_OPT_IN_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Opt in Date';

Line 10: G_POSTPONEMENT_TYPE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Postponement Type';

6: G_QUALIFYING_SCHEME_NAME CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Qualifying Scheme Name';
7: G_AGG_EARNINGS_PENSIONS CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Aggregate Earnings';
8: G_AUTO_ENROLLMENT_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Auto Enrollment Date';
9: G_QUALIFYING_PS_EXISTS CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Qualifying scheme exists';
10: G_POSTPONEMENT_TYPE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Postponement Type';
11: G_POSTPONEMENT_END_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Postponement End Date';
12: G_EMPLOYEE_CLASS CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Pension Classification';
13: G_OPT_IN_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Opt in Date';
14: G_OPT_OUT_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Opt Out Date';

Line 11: G_POSTPONEMENT_END_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Postponement End Date';

7: G_AGG_EARNINGS_PENSIONS CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Aggregate Earnings';
8: G_AUTO_ENROLLMENT_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Auto Enrollment Date';
9: G_QUALIFYING_PS_EXISTS CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Qualifying scheme exists';
10: G_POSTPONEMENT_TYPE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Postponement Type';
11: G_POSTPONEMENT_END_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Postponement End Date';
12: G_EMPLOYEE_CLASS CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Pension Classification';
13: G_OPT_IN_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Opt in Date';
14: G_OPT_OUT_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Opt Out Date';
15: G_OPT_OUT_END_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Opt Out Period End Date';

Line 12: G_EMPLOYEE_CLASS CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Pension Classification';

8: G_AUTO_ENROLLMENT_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Auto Enrollment Date';
9: G_QUALIFYING_PS_EXISTS CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Qualifying scheme exists';
10: G_POSTPONEMENT_TYPE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Postponement Type';
11: G_POSTPONEMENT_END_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Postponement End Date';
12: G_EMPLOYEE_CLASS CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Pension Classification';
13: G_OPT_IN_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Opt in Date';
14: G_OPT_OUT_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Opt Out Date';
15: G_OPT_OUT_END_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Opt Out Period End Date';
16: G_MAIN_ENTRY CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Main Entry for Aggregation';

Line 13: G_OPT_IN_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Opt in Date';

9: G_QUALIFYING_PS_EXISTS CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Qualifying scheme exists';
10: G_POSTPONEMENT_TYPE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Postponement Type';
11: G_POSTPONEMENT_END_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Postponement End Date';
12: G_EMPLOYEE_CLASS CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Pension Classification';
13: G_OPT_IN_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Opt in Date';
14: G_OPT_OUT_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Opt Out Date';
15: G_OPT_OUT_END_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Opt Out Period End Date';
16: G_MAIN_ENTRY CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Main Entry for Aggregation';
17: G_TOTAL_EARNING_PRP CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Total Earning PRP';

Line 14: G_OPT_OUT_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Opt Out Date';

10: G_POSTPONEMENT_TYPE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Postponement Type';
11: G_POSTPONEMENT_END_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Postponement End Date';
12: G_EMPLOYEE_CLASS CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Pension Classification';
13: G_OPT_IN_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Opt in Date';
14: G_OPT_OUT_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Opt Out Date';
15: G_OPT_OUT_END_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Opt Out Period End Date';
16: G_MAIN_ENTRY CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Main Entry for Aggregation';
17: G_TOTAL_EARNING_PRP CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Total Earning PRP';
18: G_ELIGIBLE_JH_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Eligible Job Holder Date';

Line 15: G_OPT_OUT_END_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Opt Out Period End Date';

11: G_POSTPONEMENT_END_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Postponement End Date';
12: G_EMPLOYEE_CLASS CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Pension Classification';
13: G_OPT_IN_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Opt in Date';
14: G_OPT_OUT_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Opt Out Date';
15: G_OPT_OUT_END_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Opt Out Period End Date';
16: G_MAIN_ENTRY CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Main Entry for Aggregation';
17: G_TOTAL_EARNING_PRP CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Total Earning PRP';
18: G_ELIGIBLE_JH_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Eligible Job Holder Date';
19:

Line 16: G_MAIN_ENTRY CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Main Entry for Aggregation';

12: G_EMPLOYEE_CLASS CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Pension Classification';
13: G_OPT_IN_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Opt in Date';
14: G_OPT_OUT_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Opt Out Date';
15: G_OPT_OUT_END_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Opt Out Period End Date';
16: G_MAIN_ENTRY CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Main Entry for Aggregation';
17: G_TOTAL_EARNING_PRP CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Total Earning PRP';
18: G_ELIGIBLE_JH_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Eligible Job Holder Date';
19:
20: G_EXCEPTION_NO_UPDATE EXCEPTION;-- To be used only if error is to be raised, to be used after populate_run_msg

Line 17: G_TOTAL_EARNING_PRP CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Total Earning PRP';

13: G_OPT_IN_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Opt in Date';
14: G_OPT_OUT_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Opt Out Date';
15: G_OPT_OUT_END_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Opt Out Period End Date';
16: G_MAIN_ENTRY CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Main Entry for Aggregation';
17: G_TOTAL_EARNING_PRP CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Total Earning PRP';
18: G_ELIGIBLE_JH_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Eligible Job Holder Date';
19:
20: G_EXCEPTION_NO_UPDATE EXCEPTION;-- To be used only if error is to be raised, to be used after populate_run_msg
21: G_ERROR VARCHAR2(1):='N';

Line 18: G_ELIGIBLE_JH_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Eligible Job Holder Date';

14: G_OPT_OUT_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Opt Out Date';
15: G_OPT_OUT_END_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Opt Out Period End Date';
16: G_MAIN_ENTRY CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Main Entry for Aggregation';
17: G_TOTAL_EARNING_PRP CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Total Earning PRP';
18: G_ELIGIBLE_JH_DATE CONSTANT PAY_INPUT_VALUES_F.NAME%TYPE := 'Eligible Job Holder Date';
19:
20: G_EXCEPTION_NO_UPDATE EXCEPTION;-- To be used only if error is to be raised, to be used after populate_run_msg
21: G_ERROR VARCHAR2(1):='N';
22: --Payroll Period

Line 83: PAY_INPUT_VALUES_F PIVF

79: MAX(DECODE(TRIM(PIVF.NAME),G_MAIN_ENTRY,PIVF.INPUT_VALUE_ID, NULL)) G_MAIN_ENTRY_ID,
80: MAX(DECODE(TRIM(PIVF.NAME),G_TOTAL_EARNING_PRP,PIVF.INPUT_VALUE_ID, NULL)) G_TOTAL_EARNING_PRP_ID,
81: MAX(DECODE(TRIM(PIVF.NAME),G_ELIGIBLE_JH_DATE,PIVF.INPUT_VALUE_ID, NULL)) G_ELIGIBLE_JH_DATE_ID
82: FROM PAY_ELEMENT_TYPES_F PETF,
83: PAY_INPUT_VALUES_F PIVF
84: WHERE PETF.ELEMENT_NAME = G_ELEMENT_NAME
85: AND PETF.ELEMENT_TYPE_ID = PIVF.ELEMENT_TYPE_ID
86: -- AND G_PRP_END_DATE BETWEEN PETF.EFFECTIVE_START_DATE AND PETF.EFFECTIVE_END_DATE
87: -- AND G_PRP_END_DATE BETWEEN PIVF.EFFECTIVE_START_DATE AND PIVF.EFFECTIVE_END_DATE

Line 190: PAY_INPUT_VALUES_F PIVF

186: CURSOR C_SCREEN_ENTRY_VALUE(P_ELEMENT_ENTRY_ID VARCHAR2,P_EFFECTIVE_DATE DATE)
187: IS
188: SELECT PEEVF.SCREEN_ENTRY_VALUE
189: FROM PAY_ELEMENT_ENTRY_VALUES_F PEEVF ,
190: PAY_INPUT_VALUES_F PIVF
191: WHERE PEEVF.ELEMENT_ENTRY_ID = P_ELEMENT_ENTRY_ID
192: AND PIVF.NAME ='Pay Value'
193: AND PEEVF.INPUT_VALUE_ID =PIVF.INPUT_VALUE_ID
194: AND P_EFFECTIVE_DATE BETWEEN PIVF.EFFECTIVE_START_DATE AND PIVF.EFFECTIVE_END_DATE

Line 208: FROM PAY_ELEMENT_ENTRY_VALUES_F PEEF, PAY_INPUT_VALUES_F PIVF

204: --Fetch Screen Entry value for an input value
205: CURSOR ELE_SCREEN_VALUE (P_ELEM_ENTRY_ID NUMBER)
206: IS
207: SELECT PEEF.SCREEN_ENTRY_VALUE, PEEF.INPUT_VALUE_ID, UPPER(REPLACE(PIVF.NAME,' ','_')) NAME
208: FROM PAY_ELEMENT_ENTRY_VALUES_F PEEF, PAY_INPUT_VALUES_F PIVF
209: WHERE PEEF.ELEMENT_ENTRY_ID = P_ELEM_ENTRY_ID
210: AND PEEF.INPUT_VALUE_ID = PIVF.INPUT_VALUE_ID
211: AND G_PRP_END_DATE >= ALL(PEEF.EFFECTIVE_START_DATE,PIVF.EFFECTIVE_START_DATE )
212: AND G_PRP_START_DATE <= ALL(PEEF.EFFECTIVE_END_DATE,PIVF.EFFECTIVE_END_DATE ) ;