APPS.PER_PCE_BUS dependencies on PER_COLLECTIVE_AGREEMENTS

Line 31: per_collective_agreements pca

27: CURSOR csr_sec_grp IS
28: SELECT pbg.security_group_id
29: FROM per_business_groups pbg,
30: per_cagr_entitlements pce,
31: per_collective_agreements pca
32: WHERE pce.cagr_entitlement_id = p_cagr_entitlement_id
33: AND pca.collective_agreement_id = p_collective_agreement_id
34: AND pbg.business_group_id = pca.business_group_id;
35:

Line 96: per_collective_agreements pca

92: CURSOR csr_leg_code IS
93: SELECT pbg.legislation_code
94: FROM per_business_groups pbg,
95: per_cagr_entitlements pce,
96: per_collective_agreements pca
97: WHERE pce.cagr_entitlement_id = p_cagr_entitlement_id
98: AND pca.collective_agreement_id = p_collective_agreement_id
99: AND pbg.business_group_id = pca.business_group_id;
100: --

Line 682: -- PER_COLLECTIVE_AGREEMENTS table.

678: --
679: -- Desciption :
680: --
681: -- Validates that the collective_agreement_id exists in the
682: -- PER_COLLECTIVE_AGREEMENTS table.
683: --
684: --
685: -- Pre-conditions :
686: --

Line 715: FROM per_collective_agreements cag

711: -- Declare Cursors
712: --
713: CURSOR chk_id IS
714: SELECT cag.collective_agreement_id
715: FROM per_collective_agreements cag
716: WHERE cag.business_group_id = p_business_group_id
717: AND cag.collective_agreement_id = p_collective_agreement_id;
718: --
719: -- Declare Local variables

Line 941: FROM per_collective_agreements pca

937: -- Define cursors
938: --
939: CURSOR chk_collective_agreement_date IS
940: SELECT pca.start_date
941: FROM per_collective_agreements pca
942: WHERE p_start_date < pca.start_date
943: AND pca.collective_Agreement_id = p_collective_agreement_id;
944: --
945: l_proc VARCHAR2(72) := g_package||'chk_start_date';