DBA Data[Home] [Help]

APPS.PAY_SIMULATOR_PKG dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 511: FROM per_assignment_extra_info pae,

507: CURSOR csr_simulation_elements(p_ass_id NUMBER, p_sim_region3 VARCHAR2, p_sim_region4 VARCHAR2)
508: IS
509: SELECT DISTINCT
510: piv.element_type_id
511: FROM per_assignment_extra_info pae,
512: pay_input_values_f piv
513: WHERE pae.assignment_id = p_ass_id
514: AND pae.information_type IN (p_sim_region3,p_sim_region4)
515: AND piv.input_value_id = pae.aei_information1

Line 523: FROM per_assignment_extra_info pae,

519: IS
520: SELECT DISTINCT
521: pae.aei_information1 input_value_id,
522: pae.aei_information2 what_if_value
523: FROM per_assignment_extra_info pae,
524: pay_input_values_f piv
525: WHERE pae.assignment_id = p_ass_id
526: AND pae.information_type IN (p_sim_region3,p_sim_region4)
527: AND piv.input_value_id = pae.aei_information1

Line 1288: FROM per_assignment_extra_info

1284: ,aei_information27
1285: ,aei_information28
1286: ,aei_information29
1287: ,aei_information30
1288: FROM per_assignment_extra_info
1289: WHERE assignment_id = p_assignment_id;
1290:
1291: COMMIT;
1292: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);