DBA Data[Home] [Help]

APPS.PAY_FI_ARCHIVE_DPSA dependencies on PAY_ELEMENT_TYPES_F

Line 838: ,pay_element_types_f et

834: FROM per_all_assignments_f asg1
835: ,per_all_assignments_f asg2
836: ,per_all_people_f per
837: ,pay_element_links_f el
838: ,pay_element_types_f et
839: ,pay_input_values_f iv1
840: ,pay_element_entries_f ee
841: ,pay_element_entry_values_f eev1
842: WHERE asg1.assignment_id = p_assignment_id

Line 898: pay_element_types_f petf,

894: p_input_val_name IN VARCHAR2) IS
895: SELECT prrv.result_value FROM
896: pay_assignment_actions paa,
897: pay_run_results prr,
898: pay_element_types_f petf,
899: pay_input_values_f pivf,
900: pay_run_result_values prrv
901: WHERE paa.assignment_id = p_assignment_id
902: AND paa.assignment_action_id = prr.assignment_action_id

Line 913: pay_element_types_f

909: AND prrv.run_result_id = prr.run_result_id
910: AND paa.action_sequence = (SELECT MAX(paa.action_sequence) FROM
911: pay_assignment_actions paa,
912: pay_run_results prr,
913: pay_element_types_f
914: WHERE paa.assignment_id = p_assignment_id
915: AND paa.assignment_action_id = prr.assignment_action_id
916: AND prr.element_type_id = petf.element_type_id
917: AND petf.element_name = p_element_name