APPS.PER_CAG_BUS dependencies on PER_CAGR_GRADE_STRUCTURES

Line 701: from per_cagr_grade_structures pcg

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
702: where pcg.collective_agreement_id = p_rec.collective_agreement_id;
703:
704: CURSOR csr_entitlement IS
705: SELECT 1

Line 747: -- If the collective agreements exits in per_cagr_grade_structures

743: close csr_establishment;
744: --
745: hr_utility.set_location(l_proc, 20);
746: --
747: -- If the collective agreements exits in per_cagr_grade_structures
748: --
749: open csr_grade;
750: fetch csr_grade into l_dummy;
751: if csr_grade%found then