APPS.PAY_GB_ENROLL_PENSION dependencies on PAY_ELEMENT_TYPES_F

Line 200: pay_element_types_f petf,

196: IS
197: SELECT MAX(DECODE(pivf.name,'Aggregate Earnings',peevf.screen_entry_value)) Agg_earnings,
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

Line 228: pay_element_types_f petf,

224: MAX(DECODE(pivf.name,'Opt Out Date',peevf.screen_entry_value)) OPT_OUT,
225: MAX(DECODE(pivf.name,'Postponement End Date',peevf.screen_entry_value)) POSTPONEMENT,
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

Line 551: FROM pay_element_types_f petf

547:
548: cursor csr_element_entries_for_update
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

Line 1074: FROM pay_element_types_f petf ,

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 ,
1075: PAY_ELEMENT_CLASSIFICATIONS PEC
1076: WHERE Petf.CLASSIFICATION_ID = PEC.CLASSIFICATION_ID
1077: AND PEC.CLASSIFICATION_NAME = 'Information'
1078: AND PETF.ELEMENT_NAME NOT IN ('NI','PAYE')

Line 1176: FROM pay_element_types_f petf ,

1172: --Created for Pensions 2 - to fetch elements which have been missed out in the payroll run for that assignment_action_id
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

Line 2889: FROM PAY_ELEMENT_TYPES_F

2885: ORDER BY REGULAR_PAYMENT_DATE;
2886: CURSOR C_ELEMENT_INFO
2887: IS
2888: SELECT ELEMENT_TYPE_ID
2889: FROM PAY_ELEMENT_TYPES_F
2890: WHERE ELEMENT_NAME =P_ELEMENT_TYPE_NAME
2891: AND BUSINESS_GROUP_ID = G_BUSINESS_GROUP_ID
2892: AND V_EFF_START_DATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
2893: -- Cursor to fetch all Active Aggregated assignments across payrolls

Line 3966: PAY_ELEMENT_TYPES_F PETF ,

3962: IS
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

Line 3983: PAY_ELEMENT_TYPES_F PETF ,

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 ,
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

Line 4107: FROM pay_element_types_f

4103: FROM pay_element_entries_f
4104: WHERE element_type_id =
4105: (
4106: SELECT element_type_id
4107: FROM pay_element_types_f
4108: WHERE element_name LIKE 'Pensions Information'
4109: )
4110: AND assignment_id = P_ASSIGNMENT_ID
4111: )

Line 4119: FROM pay_element_types_f

4115: FROM pay_input_values_f
4116: WHERE element_type_id =
4117: (
4118: SELECT element_type_id
4119: FROM pay_element_types_f
4120: WHERE element_name LIKE 'Pensions Information'
4121: )
4122: AND name = 'Pension Classification'
4123: )

Line 4131: FROM pay_element_types_f

4127: FROM pay_input_values_f
4128: WHERE element_type_id =
4129: (
4130: SELECT element_type_id
4131: FROM pay_element_types_f
4132: WHERE element_name LIKE 'Pensions Information'
4133: )
4134: AND name = 'Qualifying scheme exists'
4135: )

Line 4149: PAY_ELEMENT_TYPES_F PETF ,

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 ,
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