APPS.HR_US_REPORTS dependencies on PAY_PAYROLL_ACTIONS

Line 877: FROM pay_payroll_actions

873: begin
874: hr_utility.set_location('hr_us_reports.get_payroll_action',5);
875: SELECT action_type
876: INTO l_action_type
877: FROM pay_payroll_actions
878: WHERE payroll_action_id = p_payroll_action_id;
879: --
880: exception when NO_DATA_FOUND then RETURN NULL;
881: end;

Line 889: pay_payroll_actions ppa

885: SELECT ppa.display_run_number || '-' || pcs.consolidation_set_name
886: || '-' || ppa.effective_date || '-' || ppa.payroll_action_id
887: INTO l_payroll_action_name
888: FROM pay_consolidation_sets pcs,
889: pay_payroll_actions ppa
890: WHERE ppa.consolidation_set_id = pcs.consolidation_set_id
891: AND ppa.payroll_action_id = p_payroll_action_id;
892: exception
893: when no_data_found then RETURN NULL;

Line 903: pay_payroll_actions ppa

899: || '-' || pes.element_set_name
900: INTO l_payroll_action_name
901: FROM hr_assignment_sets has,
902: pay_element_sets pes,
903: pay_payroll_actions ppa
904: WHERE has.assignment_set_id(+) = ppa.assignment_set_id
905: AND pes.element_set_id(+) = ppa.element_set_id
906: AND ppa.payroll_action_id = p_payroll_action_id;
907: exception

Line 917: pay_payroll_actions ppa

913: INTO l_payroll_action_name
914: FROM per_people_f ppe,
915: per_all_assignments_f pas,
916: pay_assignment_actions paa,
917: pay_payroll_actions ppa
918: WHERE ppe.person_id = pas.person_id
919: AND pas.assignment_id = paa.assignment_id
920: AND paa.payroll_action_id = ppa.payroll_action_id
921: AND ppa.payroll_action_id = p_payroll_action_id