DBA Data[Home] [Help]

APPS.PAY_KW_ANNUAL_REPORTS dependencies on PAY_INPUT_VALUES_F

Line 1452: pay_input_values_f piv

1448: FROM pay_element_types_f pet,
1449: pay_element_entries_f pee,
1450: pay_run_results prr,
1451: pay_run_result_values rrv,
1452: pay_input_values_f piv
1453: WHERE rrv.RUN_RESULT_ID = prr.RUN_RESULT_ID
1454: AND prr.assignment_action_id = l_assignment_action_id
1455: AND prr.ELEMENT_ENTRY_ID = pee.ELEMENT_ENTRY_ID
1456: AND piv.element_type_id = pet.element_type_id

Line 1473: pay_input_values_f piv1,

1469: eev4.SCREEN_ENTRY_VALUE debt,eev1.effective_start_date start_d,eev1.effective_end_date end_d, pet.element_type_id
1470: from pay_element_entry_values_f eev1,
1471: pay_element_types_f pet,
1472: pay_element_entries_f pee,
1473: pay_input_values_f piv1,
1474: pay_input_values_f piv2,
1475: pay_input_values_f piv3,
1476: pay_input_values_f piv4,
1477: pay_element_entry_values_f eev2,

Line 1474: pay_input_values_f piv2,

1470: from pay_element_entry_values_f eev1,
1471: pay_element_types_f pet,
1472: pay_element_entries_f pee,
1473: pay_input_values_f piv1,
1474: pay_input_values_f piv2,
1475: pay_input_values_f piv3,
1476: pay_input_values_f piv4,
1477: pay_element_entry_values_f eev2,
1478: pay_element_entry_values_f eev3,

Line 1475: pay_input_values_f piv3,

1471: pay_element_types_f pet,
1472: pay_element_entries_f pee,
1473: pay_input_values_f piv1,
1474: pay_input_values_f piv2,
1475: pay_input_values_f piv3,
1476: pay_input_values_f piv4,
1477: pay_element_entry_values_f eev2,
1478: pay_element_entry_values_f eev3,
1479: pay_element_entry_values_f eev4

Line 1476: pay_input_values_f piv4,

1472: pay_element_entries_f pee,
1473: pay_input_values_f piv1,
1474: pay_input_values_f piv2,
1475: pay_input_values_f piv3,
1476: pay_input_values_f piv4,
1477: pay_element_entry_values_f eev2,
1478: pay_element_entry_values_f eev3,
1479: pay_element_entry_values_f eev4
1480: where pet.element_name = 'Additional Social Insurance Information'