APPS.HR_US_REPORTS dependencies on PAY_PAYROLL_ACTIONS

Line 895: FROM pay_payroll_actions

891: begin
892: hr_utility.set_location('hr_us_reports.get_payroll_action',5);
893: SELECT action_type
894: INTO l_action_type
895: FROM pay_payroll_actions
896: WHERE payroll_action_id = p_payroll_action_id;
897: --
898: exception when NO_DATA_FOUND then RETURN NULL;
899: end;

Line 907: pay_payroll_actions ppa

903: SELECT ppa.display_run_number || '-' || pcs.consolidation_set_name
904: || '-' || ppa.effective_date || '-' || ppa.payroll_action_id
905: INTO l_payroll_action_name
906: FROM pay_consolidation_sets pcs,
907: pay_payroll_actions ppa
908: WHERE ppa.consolidation_set_id = pcs.consolidation_set_id
909: AND ppa.payroll_action_id = p_payroll_action_id;
910: exception
911: when no_data_found then RETURN NULL;

Line 921: pay_payroll_actions ppa

917: || '-' || pes.element_set_name
918: INTO l_payroll_action_name
919: FROM hr_assignment_sets has,
920: pay_element_sets pes,
921: pay_payroll_actions ppa
922: WHERE has.assignment_set_id(+) = ppa.assignment_set_id
923: AND pes.element_set_id(+) = ppa.element_set_id
924: AND ppa.payroll_action_id = p_payroll_action_id;
925: exception

Line 935: pay_payroll_actions ppa

931: INTO l_payroll_action_name
932: FROM per_people_f ppe,
933: per_all_assignments_f pas,
934: pay_assignment_actions paa,
935: pay_payroll_actions ppa
936: WHERE ppe.person_id = pas.person_id
937: AND pas.assignment_id = paa.assignment_id
938: AND paa.payroll_action_id = ppa.payroll_action_id
939: AND ppa.payroll_action_id = p_payroll_action_id