APPS.PQH_CRF_BUS dependencies on PQH_CRITERIA_RATE_FACTORS

Line 31: , pqh_criteria_rate_factors crf

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_criteria_rate_factors crf
32: where crf.criteria_rate_factor_id = p_criteria_rate_factor_id
33: and pbg.business_group_id (+) = crf.business_group_id;
34: --
35: -- Declare local variables

Line 101: , pqh_criteria_rate_factors crf

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

Line 335: pqh_crf_shd.constraint_error('PQH_CRITERIA_RATE_FACTORS_FK1');

331: --
332: -- raise error as FK does not relate to PK in PQH_CRITERIA_RATE_DEFN
333: -- table.
334: --
335: pqh_crf_shd.constraint_error('PQH_CRITERIA_RATE_FACTORS_FK1');
336: --
337: end if;
338: --
339: close c1;

Line 418: pqh_crf_shd.constraint_error('PQH_CRITERIA_RATE_FACTORS_FK4');

414: --
415: -- raise error as FK does not relate to PK in BEN_PL_F
416: -- table.
417: --
418: pqh_crf_shd.constraint_error('PQH_CRITERIA_RATE_FACTORS_FK4');
419: --
420: end if;
421: --
422: close c1;

Line 504: pqh_crf_shd.constraint_error('PQH_CRITERIA_RATE_FACTORS_FK3');

500: --
501: -- raise error as FK does not relate to PK in HR_ALL_ORGANIZATION_UNITS
502: -- table.
503: --
504: pqh_crf_shd.constraint_error('PQH_CRITERIA_RATE_FACTORS_FK3');
505: --
506: end if;
507: --
508: close c1;