APPS.HR_US_REPORTS dependencies on PAY_CONSOLIDATION_SETS

Line 739: FROM pay_consolidation_sets

735: begin
736: hr_utility.set_location('hr_us_reports.get_consolidation_set',5);
737: SELECT consolidation_set_name
738: INTO l_consolidation_set_name
739: FROM pay_consolidation_sets
740: WHERE consolidation_set_id = p_consolidation_set_id;
741: --
742: exception when NO_DATA_FOUND then RETURN NULL;
743: end;

Line 888: FROM pay_consolidation_sets pcs,

884: hr_utility.set_location('hr_us_reports.get_payroll_action',10);
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