APPS.PQH_RFE_BUS dependencies on PQH_RATE_FACTOR_ON_ELMNTS

Line 31: , pqh_rate_factor_on_elmnts rfe

27: cursor csr_sec_grp is
28: select pbg.security_group_id,
29: pbg.legislation_code
30: from per_business_groups_perf pbg
31: , pqh_rate_factor_on_elmnts rfe
32: where rfe.rate_factor_on_elmnt_id = p_rate_factor_on_elmnt_id
33: and pbg.business_group_id (+) = rfe.business_group_id;
34: --
35: -- Declare local variables

Line 101: , pqh_rate_factor_on_elmnts rfe

97: --
98: cursor csr_leg_code is
99: select pbg.legislation_code
100: from per_business_groups_perf pbg
101: , pqh_rate_factor_on_elmnts rfe
102: where rfe.rate_factor_on_elmnt_id = p_rate_factor_on_elmnt_id
103: and pbg.business_group_id (+) = rfe.business_group_id;
104: --
105: -- Declare local variables

Line 385: pqh_rfe_shd.constraint_error('PQH_RATE_FACTOR_ON_ELMNTS_FK1');

381: --
382: -- raise error as FK does not relate to PK in pqh_criteria_rate_elements
383: -- table.
384: --
385: pqh_rfe_shd.constraint_error('PQH_RATE_FACTOR_ON_ELMNTS_FK1');
386: --
387: end if;
388: --
389: close c1;

Line 468: pqh_rfe_shd.constraint_error('PQH_RATE_FACTOR_ON_ELMNTS_FK2');

464: --
465: -- raise error as FK does not relate to PK in pqh_criteria_rate_factors
466: -- table.
467: --
468: pqh_rfe_shd.constraint_error('PQH_RATE_FACTOR_ON_ELMNTS_FK2');
469: --
470: end if;
471: --
472: close c1;

Line 671: pqh_rfe_shd.constraint_error('PQH_RATE_FACTOR_ON_ELMNTS_FK3');

667: --
668: -- raise error as FK does not relate to PK in HR_ALL_ORGANIZATION_UNITS
669: -- table.
670: --
671: pqh_rfe_shd.constraint_error('PQH_RATE_FACTOR_ON_ELMNTS_FK3');
672: --
673: end if;
674: --
675: close c1;