APPS.PAY_KW_ANNUAL_REPORTS dependencies on PAY_INPUT_VALUES_F

Line 1510: pay_input_values_f piv

1506: FROM pay_element_types_f pet,
1507: pay_element_entries_f pee,
1508: pay_run_results prr,
1509: pay_run_result_values rrv,
1510: pay_input_values_f piv
1511: WHERE rrv.RUN_RESULT_ID = prr.RUN_RESULT_ID
1512: AND prr.assignment_action_id = l_assignment_action_id
1513: AND prr.ELEMENT_ENTRY_ID = pee.ELEMENT_ENTRY_ID
1514: AND piv.element_type_id = pet.element_type_id

Line 1531: pay_input_values_f piv1,

1527: eev4.SCREEN_ENTRY_VALUE debt,eev1.effective_start_date start_d,eev1.effective_end_date end_d, pet.element_type_id
1528: from pay_element_entry_values_f eev1,
1529: pay_element_types_f pet,
1530: pay_element_entries_f pee,
1531: pay_input_values_f piv1,
1532: pay_input_values_f piv2,
1533: pay_input_values_f piv3,
1534: pay_input_values_f piv4,
1535: pay_element_entry_values_f eev2,

Line 1532: pay_input_values_f piv2,

1528: from pay_element_entry_values_f eev1,
1529: pay_element_types_f pet,
1530: pay_element_entries_f pee,
1531: pay_input_values_f piv1,
1532: pay_input_values_f piv2,
1533: pay_input_values_f piv3,
1534: pay_input_values_f piv4,
1535: pay_element_entry_values_f eev2,
1536: pay_element_entry_values_f eev3,

Line 1533: pay_input_values_f piv3,

1529: pay_element_types_f pet,
1530: pay_element_entries_f pee,
1531: pay_input_values_f piv1,
1532: pay_input_values_f piv2,
1533: pay_input_values_f piv3,
1534: pay_input_values_f piv4,
1535: pay_element_entry_values_f eev2,
1536: pay_element_entry_values_f eev3,
1537: pay_element_entry_values_f eev4

Line 1534: pay_input_values_f piv4,

1530: pay_element_entries_f pee,
1531: pay_input_values_f piv1,
1532: pay_input_values_f piv2,
1533: pay_input_values_f piv3,
1534: pay_input_values_f piv4,
1535: pay_element_entry_values_f eev2,
1536: pay_element_entry_values_f eev3,
1537: pay_element_entry_values_f eev4
1538: where pet.element_name = 'Additional Social Insurance Information'