[Home] [Help]
APPS.HR_COLLECTIVE_AGREEMENT_API dependencies on PER_CAGR_ENTITLEMENTS
Line 1044: FROM per_cagr_entitlements pce
1040: l_end_date DATE;
1041: --
1042: CURSOR csr_chk_for_entitlements IS
1043: SELECT 'x'
1044: FROM per_cagr_entitlements pce
1045: WHERE pce.collective_agreement_id = p_collective_agreement_id;
1046: --
1047: CURSOR csr_pln IS
1048: SELECT b.pl_id,