eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_PCE_BUS dependencies on PER_BUSINESS_GROUPS

Line 29: FROM per_business_groups pbg,

25: -- Declare cursor
26: --
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

Line 94: FROM per_business_groups pbg,

90: --
91:
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

Line 805: per_business_groups pg

801: CURSOR chk_formula_id IS
802: SELECT ff.formula_id
803: FROM ff_formulas_f ff,
804: ff_formula_types ft,
805: per_business_groups pg
806: WHERE NVL(ff.legislation_code, pg.legislation_code) =
807: pg.legislation_code
808: AND NVL(ff.business_group_id,p_business_group_id) =
809: pg.business_group_id