DBA Data[Home] [Help]

APPS.PER_CAG_BUS dependencies on HR_ESTAB_COLL_AGRS_V

Line 697: from hr_estab_coll_agrs_v hfe

693: from per_all_assignments_f paa
694: where paa.collective_agreement_id = p_rec.collective_agreement_id;
695:
696: cursor csr_establishment is select '1'
697: from hr_estab_coll_agrs_v hfe
698: where to_number(substr(hfe.collective_agreement_id,1,30)) = p_rec.collective_agreement_id;
699:
700: cursor csr_grade is select '1'
701: from per_cagr_grade_structures pcg