APPS.HR_US_REPORTS dependencies on PAY_CONSOLIDATION_SETS

Line 757: FROM pay_consolidation_sets

753: begin
754: hr_utility.set_location('hr_us_reports.get_consolidation_set',5);
755: SELECT consolidation_set_name
756: INTO l_consolidation_set_name
757: FROM pay_consolidation_sets
758: WHERE consolidation_set_id = p_consolidation_set_id;
759: --
760: exception when NO_DATA_FOUND then RETURN NULL;
761: end;

Line 906: FROM pay_consolidation_sets pcs,

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