APPS.PQH_CRE_BUS dependencies on PQH_CRITERIA_RATE_ELEMENTS

Line 31: , pqh_criteria_rate_elements cre

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_elements cre
32: where cre.criteria_rate_element_id = p_criteria_rate_element_id
33: and pbg.business_group_id (+) = cre.business_group_id;
34: --
35: -- Declare local variables

Line 101: , pqh_criteria_rate_elements cre

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

Line 335: pqh_cre_shd.constraint_error('PQH_CRITERIA_RATE_ELEMENTS_FK1');

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

Line 418: pqh_cre_shd.constraint_error('PQH_CRITERIA_RATE_ELEMENTS_FK3');

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

Line 501: pqh_cre_shd.constraint_error('PQH_CRITERIA_RATE_ELEMENTS_FK4');

497: --
498: -- raise error as FK does not relate to PK in PAY_ELEMENT_TYPES_F
499: -- table.
500: --
501: pqh_cre_shd.constraint_error('PQH_CRITERIA_RATE_ELEMENTS_FK4');
502: --
503: end if;
504: --
505: close c1;

Line 585: pqh_cre_shd.constraint_error('PQH_CRITERIA_RATE_ELEMENTS_FK5');

581: --
582: -- raise error as FK does not relate to PK in PAY_INPUT_VALUES_F
583: -- table.
584: --
585: pqh_cre_shd.constraint_error('PQH_CRITERIA_RATE_ELEMENTS_FK5');
586: --
587: end if;
588: --
589: close c1;