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_ELEMENT_ENTRIES_F

Line 202: pay_element_entries_f peef,

198: MAX(DECODE(pivf.name,'Main Entry for Aggregation',peevf.screen_entry_value)) Main_entry
199: FROM per_all_assignments_f paaf,
200: pay_element_types_f petf,
201: pay_input_values_f pivf,
202: pay_element_entries_f peef,
203: pay_element_entry_values_f peevf
204: WHERE paaf.assignment_id = V_ASSIGNMENT_ID
205: AND petf.element_name ='Pensions Information'
206: AND petf.legislation_code = 'GB'

Line 230: pay_element_entries_f peef,

226: MAX(DECODE(pivf.name,'Eligible Job Holder Date',peevf.screen_entry_value)) EJH
227: FROM per_all_assignments_f paaf,
228: pay_element_types_f petf,
229: pay_input_values_f pivf,
230: pay_element_entries_f peef,
231: pay_element_entry_values_f peevf
232: WHERE paaf.assignment_id = V_ASSIGNMENT_ID
233: AND petf.element_name ='Pensions Information'
234: AND petf.legislation_code = 'GB'

Line 553: ,pay_element_entries_f peef

549: is
550: SELECT peevf.*
551: FROM pay_element_types_f petf
552: ,pay_input_values_f pivf
553: ,pay_element_entries_f peef
554: ,pay_element_entry_values_f peevf
555: WHERE
556: petf.element_name = 'NI'
557: AND petf.legislation_code = 'GB'

Line 854: FROM pay_element_entries_f peef

850: -- Fetch Original Entry Id for the Element Entry -- Bug 14080693
851: CURSOR C_ORIGINAL_ENTRY_ID
852: IS
853: SELECT ORIGINAL_ENTRY_ID
854: FROM pay_element_entries_f peef
855: WHERE peef.element_entry_id = P_ELEM_ENTRY_ID
856: AND g_payroll_end_date BETWEEN peef.effective_start_date AND peef.effective_end_date;
857: -- Fetch Element Type Id for the Element Entry Id -- Bug 14064422
858: CURSOR C_ELEMENT_TYPE_ID

Line 861: FROM pay_element_entries_f peef ,

857: -- Fetch Element Type Id for the Element Entry Id -- Bug 14064422
858: CURSOR C_ELEMENT_TYPE_ID
859: IS
860: SELECT pelf.element_type_id
861: FROM pay_element_entries_f peef ,
862: pay_element_links_f pelf
863: WHERE pelf.element_link_id = peef.element_link_id
864: AND peef.element_entry_id = P_ELEM_ENTRY_ID
865: AND g_payroll_end_date BETWEEN peef.effective_start_date AND peef.effective_end_date

Line 1070: FROM PAY_ELEMENT_ENTRIES_F PEEF

1066: CURSOR C_ELEMENT_DETAILS_INFO(P_EFFECTIVE_DATE DATE , P_ASSIGNMENT_ID NUMBER)
1067: IS
1068: SELECT PEEF.ELEMENT_ENTRY_ID,
1069: PEEF.ELEMENT_TYPE_ID
1070: FROM PAY_ELEMENT_ENTRIES_F PEEF
1071: WHERE PEEF.ASSIGNMENT_ID = P_ASSIGNMENT_ID
1072: AND PEEF.ELEMENT_TYPE_ID IN
1073: ( SELECT DISTINCT ELEMENT_TYPE_ID
1074: FROM pay_element_types_f petf ,

Line 1177: pay_element_entries_f peef ,

1173: CURSOR C_MISSED_ELEMENTS(P_TIME_PERIOD_ID NUMBER,P_DATE_EARNED DATE,P_ASSIGNMENT_ID NUMBER)
1174: IS
1175: SELECT DISTINCT petf.element_type_id
1176: FROM pay_element_types_f petf ,
1177: pay_element_entries_f peef ,
1178: ff_formulas_f fff,
1179: ff_formula_types fft
1180: WHERE petf.element_type_id = peef.element_type_id
1181: AND peef.element_type_id NOT IN

Line 1323: PAY_ELEMENT_ENTRIES_F PEEF,

1319: PEEF.ELEMENT_ENTRY_ID
1320: FROM PER_ALL_PEOPLE_F PAPF,
1321: PER_ALL_ASSIGNMENTS_F PAAF,
1322: PAY_ELEMENT_ENTRY_VALUES_F PEEVF,
1323: PAY_ELEMENT_ENTRIES_F PEEF,
1324: PER_ASSIGNMENT_STATUS_TYPES PAST
1325: WHERE PAAF.PERSON_ID =PAPF.PERSON_ID
1326: AND PAPF.PERSON_ID =P_PERSON_ID
1327: AND PAAF.ASSIGNMENT_STATUS_TYPE_ID = PAST.ASSIGNMENT_STATUS_TYPE_ID

Line 2707: FROM PAY_ELEMENT_ENTRIES_F

2703: CURSOR C_ELEMENT_ENTRIES
2704: IS
2705: SELECT ELEMENT_ENTRY_ID,
2706: GREATEST(EFFECTIVE_START_DATE,G_PRP_START_DATE) START_DATE
2707: FROM PAY_ELEMENT_ENTRIES_F
2708: WHERE ASSIGNMENT_ID =P_ASSIGNMENT_ID
2709: AND ELEMENT_TYPE_ID = G_ELEMENT_DETAILS.G_ELEMENT_TYPE_ID
2710: AND (G_PRP_START_DATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE
2711: OR EFFECTIVE_START_DATE > G_PRP_START_DATE);

Line 2903: PAY_ELEMENT_ENTRIES_F PEEF,

2899: PAAF.ASSIGNMENT_NUMBER
2900: FROM PER_ALL_PEOPLE_F PAPF,
2901: PER_ALL_ASSIGNMENTS_F PAAF,
2902: PAY_ELEMENT_ENTRY_VALUES_F PEEVF,
2903: PAY_ELEMENT_ENTRIES_F PEEF,
2904: PER_ASSIGNMENT_STATUS_TYPES PAST
2905: WHERE PAAF.PERSON_ID =PAPF.PERSON_ID
2906: AND PAPF.PERSON_ID =L_PERSON_ID
2907: AND PAAF.ASSIGNMENT_STATUS_TYPE_ID = PAST.ASSIGNMENT_STATUS_TYPE_ID

Line 3053: PAY_ELEMENT_ENTRIES_F PEEF,

3049: PAAF.ASSIGNMENT_NUMBER
3050: FROM PER_ALL_PEOPLE_F PAPF,
3051: PER_ALL_ASSIGNMENTS_F PAAF,
3052: PAY_ELEMENT_ENTRY_VALUES_F PEEVF,
3053: PAY_ELEMENT_ENTRIES_F PEEF,
3054: PER_ASSIGNMENT_STATUS_TYPES PAST
3055: WHERE PAAF.PERSON_ID =PAPF.PERSON_ID
3056: AND PAPF.PERSON_ID =L_PERSON_ID
3057: AND PAAF.ASSIGNMENT_STATUS_TYPE_ID = PAST.ASSIGNMENT_STATUS_TYPE_ID

Line 3608: PAY_ELEMENT_ENTRIES_F PEEF,

3604: PEEF.ELEMENT_ENTRY_ID
3605: FROM PER_ALL_PEOPLE_F PAPF,
3606: PER_ALL_ASSIGNMENTS_F PAAF,
3607: PAY_ELEMENT_ENTRY_VALUES_F PEEVF,
3608: PAY_ELEMENT_ENTRIES_F PEEF,
3609: PER_ASSIGNMENT_STATUS_TYPES PAST
3610: WHERE PAAF.PERSON_ID =PAPF.PERSON_ID
3611: AND PAPF.PERSON_ID =P_PERSON_ID
3612: AND PAAF.ASSIGNMENT_STATUS_TYPE_ID = PAST.ASSIGNMENT_STATUS_TYPE_ID

Line 3961: CURSOR C_QUALIFYING_SCHEME_EXISTS (P_ASSIGNMENT_ID PAY_ELEMENT_ENTRIES_F.ASSIGNMENT_ID%TYPE)

3957: -- AND G_PRP_END_DATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
3958: ------------------------------------------------------------------------------------------
3959: -- Cursor to Find if Any Qualifying Scheme Exists for the Employee
3960: /* -- Bug 14210213
3961: CURSOR C_QUALIFYING_SCHEME_EXISTS (P_ASSIGNMENT_ID PAY_ELEMENT_ENTRIES_F.ASSIGNMENT_ID%TYPE)
3962: IS
3963: SELECT PPSV.PENSION_SCHEME_NAME
3964: FROM PQP_GB_PENSION_SCHEMES_V PPSV ,
3965: PQP_CONFIGURATION_VALUES PCV ,

Line 3967: PAY_ELEMENT_ENTRIES_F PEEF

3963: SELECT PPSV.PENSION_SCHEME_NAME
3964: FROM PQP_GB_PENSION_SCHEMES_V PPSV ,
3965: PQP_CONFIGURATION_VALUES PCV ,
3966: PAY_ELEMENT_TYPES_F PETF ,
3967: PAY_ELEMENT_ENTRIES_F PEEF
3968: WHERE PCV_INFORMATION_CATEGORY = 'PAY_GB_QUALIFIED_PENSIONS_INFO'
3969: AND PCV.BUSINESS_GROUP_ID = G_BUSINESS_GROUP_ID
3970: AND PCV.PCV_INFORMATION2 = PPSV.ELEMENT_NAME
3971: AND PPSV.ELEMENT_TYPE_ID = PETF.ELEMENT_TYPE_ID

Line 3979: CURSOR C_QUALIFYING_SCHEME_EXISTS (P_ASSIGNMENT_ID PAY_ELEMENT_ENTRIES_F.ASSIGNMENT_ID%TYPE)

3975: AND G_PRP_END_DATE BETWEEN PETF.EFFECTIVE_START_DATE AND PETF.EFFECTIVE_END_DATE
3976: AND G_PRP_END_DATE BETWEEN PEEF.EFFECTIVE_START_DATE AND PEEF.EFFECTIVE_END_DATE
3977: ORDER BY PETF.EFFECTIVE_START_DATE DESC;
3978: */
3979: CURSOR C_QUALIFYING_SCHEME_EXISTS (P_ASSIGNMENT_ID PAY_ELEMENT_ENTRIES_F.ASSIGNMENT_ID%TYPE)
3980: IS
3981: SELECT PCV.PCV_INFORMATION1
3982: FROM PQP_CONFIGURATION_VALUES PCV ,
3983: PAY_ELEMENT_TYPES_F PETF ,

Line 3984: PAY_ELEMENT_ENTRIES_F PEEF

3980: IS
3981: SELECT PCV.PCV_INFORMATION1
3982: FROM PQP_CONFIGURATION_VALUES PCV ,
3983: PAY_ELEMENT_TYPES_F PETF ,
3984: PAY_ELEMENT_ENTRIES_F PEEF
3985: WHERE PCV_INFORMATION_CATEGORY = 'PAY_GB_QUALIFIED_PENSIONS_INFO'
3986: AND PCV.BUSINESS_GROUP_ID = G_BUSINESS_GROUP_ID
3987: AND PCV.PCV_INFORMATION2 = PETF.ELEMENT_NAME
3988: AND PETF.BUSINESS_GROUP_ID = G_BUSINESS_GROUP_ID

Line 4005: PAY_ELEMENT_ENTRIES_F PEEF,

4001: PAAF.ASSIGNMENT_ID ,
4002: PEEF.ELEMENT_ENTRY_ID ,
4003: PAAF.ASSIGNMENT_NUMBER
4004: FROM PER_ALL_ASSIGNMENTS_F PAAF ,
4005: PAY_ELEMENT_ENTRIES_F PEEF,
4006: PAY_ASSIGNMENT_ACTIONS PAA
4007: WHERE PAAF.PAYROLL_ID = G_PAYROLL_ID
4008: AND PAAF.ASSIGNMENT_ID = PEEF.ASSIGNMENT_ID
4009: AND PAAF.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID

Line 4061: PAY_ELEMENT_ENTRIES_F PEEF,

4057: SELECT PAAF.ASSIGNMENT_NUMBER
4058: FROM PER_ALL_PEOPLE_F PAPF,
4059: PER_ALL_ASSIGNMENTS_F PAAF,
4060: PAY_ELEMENT_ENTRY_VALUES_F PEEVF,
4061: PAY_ELEMENT_ENTRIES_F PEEF,
4062: PER_ASSIGNMENT_STATUS_TYPES PAST
4063: WHERE PAAF.PERSON_ID =PAPF.PERSON_ID
4064: AND PAPF.PERSON_ID =P_PERSON_ID
4065: AND PAAF.ASSIGNMENT_STATUS_TYPE_ID = PAST.ASSIGNMENT_STATUS_TYPE_ID

Line 4103: FROM pay_element_entries_f

4099: WHERE p1.element_entry_id = p2.element_entry_id
4100: AND p1.element_entry_id IN
4101: (
4102: SELECT element_entry_id
4103: FROM pay_element_entries_f
4104: WHERE element_type_id =
4105: (
4106: SELECT element_type_id
4107: FROM pay_element_types_f

Line 4145: CURSOR C_QPS_EXISTS_ON_STAGING_DATE (P_ASSIGNMENT_ID PAY_ELEMENT_ENTRIES_F.ASSIGNMENT_ID%TYPE)

4141: /*
4142: Check if Qualifying Pensions Scheme exists for an employee on Staging Date
4143: If exists then returns Scheme name else returns null
4144: */
4145: CURSOR C_QPS_EXISTS_ON_STAGING_DATE (P_ASSIGNMENT_ID PAY_ELEMENT_ENTRIES_F.ASSIGNMENT_ID%TYPE)
4146: IS
4147: SELECT PCV.PCV_INFORMATION1
4148: FROM PQP_CONFIGURATION_VALUES PCV ,
4149: PAY_ELEMENT_TYPES_F PETF ,

Line 4150: PAY_ELEMENT_ENTRIES_F PEEF

4146: IS
4147: SELECT PCV.PCV_INFORMATION1
4148: FROM PQP_CONFIGURATION_VALUES PCV ,
4149: PAY_ELEMENT_TYPES_F PETF ,
4150: PAY_ELEMENT_ENTRIES_F PEEF
4151: WHERE PCV_INFORMATION_CATEGORY = 'PAY_GB_QUALIFIED_PENSIONS_INFO'
4152: AND PCV.BUSINESS_GROUP_ID = G_BUSINESS_GROUP_ID
4153: AND PCV.PCV_INFORMATION2 = PETF.ELEMENT_NAME
4154: AND PETF.BUSINESS_GROUP_ID = G_BUSINESS_GROUP_ID

Line 4241: L_ELEMENT_ENTRY_ID PAY_ELEMENT_ENTRIES_F.ELEMENT_ENTRY_ID%TYPE :=NULL;

4237: L_SERVICE_START DATE :=NULL;
4238: L_TEMP VARCHAR2(30);
4239: L_PERSON_ID PER_ALL_PEOPLE_F.PERSON_ID%TYPE :=NULL;
4240: L_ASSIGNMENT_ID PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE :=NULL;
4241: L_ELEMENT_ENTRY_ID PAY_ELEMENT_ENTRIES_F.ELEMENT_ENTRY_ID%TYPE :=NULL;
4242: -- L_PENSION_ENTRY_START DATE; -- Bug 14343133
4243: L_PENSION_ENTRY_END DATE;
4244: L_PENSION_ENTRY_ID NUMBER;
4245: L_FULL_NAME PER_ALL_PEOPLE_F.FULL_NAME%TYPE;