APPS.PAY_GB_ENROLL_PENSION dependencies on PAY_INPUT_VALUES_F

Line 201: pay_input_values_f pivf,

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
205: AND petf.element_name ='Pensions Information'

Line 229: pay_input_values_f pivf,

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
233: AND petf.element_name ='Pensions Information'

Line 552: ,pay_input_values_f pivf

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
556: petf.element_name = 'NI'

Line 574: from pay_input_values_f

570:
571: cursor c_get_input_value_name(l_input_value_id NUMBER)
572: is
573: select name
574: from pay_input_values_f
575: where input_value_id = l_input_value_id
576: AND LEGISLATION_CODE = 'GB';
577:
578: l_rec csr_element_entries_for_update%rowtype;

Line 887: PAY_INPUT_VALUES_F PIVF

883: SELECT PEEF.SCREEN_ENTRY_VALUE,
884: PEEF.INPUT_VALUE_ID,
885: UPPER(REPLACE(PIVF.NAME,' ','_')) NAME
886: FROM PAY_ELEMENT_ENTRY_VALUES_F PEEF,
887: PAY_INPUT_VALUES_F PIVF
888: WHERE PEEF.ELEMENT_ENTRY_ID = P_ELEM_ENTRY_ID
889: AND PEEF.INPUT_VALUE_ID = PIVF.INPUT_VALUE_ID
890: AND g_payroll_end_date BETWEEN peef.EFFECTIVE_START_DATE AND peef.EFFECTIVE_END_DATE
891: AND g_payroll_end_date BETWEEN pivf.EFFECTIVE_START_DATE AND pivf.EFFECTIVE_END_DATE ;

Line 1088: pay_input_values_f pivf

1084: CURSOR C_RESULT_RULE_NAME (P_STATUS_PROCESSING_RULE_ID NUMBER,P_EFFECTIVE_DATE DATE)
1085: IS
1086: SELECT result_name
1087: FROM pay_formula_result_rules_f frr,
1088: pay_input_values_f pivf
1089: WHERE RESULT_RULE_TYPE = 'I'
1090: AND STATUS_PROCESSING_RULE_ID= P_STATUS_PROCESSING_RULE_ID
1091: AND P_EFFECTIVE_DATE BETWEEN frr.EFFECTIVE_START_DATE AND frr.EFFECTIVE_END_DATE
1092: AND P_EFFECTIVE_DATE BETWEEN pivf.EFFECTIVE_START_DATE AND pivf.EFFECTIVE_END_DATE

Line 4115: FROM pay_input_values_f

4111: )
4112: AND p1.input_value_id =
4113: (
4114: SELECT input_value_id
4115: FROM pay_input_values_f
4116: WHERE element_type_id =
4117: (
4118: SELECT element_type_id
4119: FROM pay_element_types_f

Line 4127: FROM pay_input_values_f

4123: )
4124: AND p2.input_value_id =
4125: (
4126: SELECT input_value_id
4127: FROM pay_input_values_f
4128: WHERE element_type_id =
4129: (
4130: SELECT element_type_id
4131: FROM pay_element_types_f