APPS.PQH_RER_BUS dependencies on PQH_RATE_ELEMENT_RELATIONS

Line 31: , pqh_rate_element_relations rer

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_element_relations rer
32: where rer.rate_element_relation_id = p_rate_element_relation_id
33: and pbg.business_group_id (+) = rer.business_group_id;
34: --
35: -- Declare local variables

Line 101: , pqh_rate_element_relations rer

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

Line 341: pqh_rer_shd.constraint_error('PQH_RATE_ELEMENT_RELATIONS_FK1');

337: --
338: -- raise error as FK does not relate to PK in PQH_CRITERIA_RATE_ELEMENTS
339: -- table.
340: --
341: pqh_rer_shd.constraint_error('PQH_RATE_ELEMENT_RELATIONS_FK1');
342: --
343: end if;
344: --
345: close c1;

Line 430: pqh_rer_shd.constraint_error('PQH_RATE_ELEMENT_RELATIONS_FK4');

426: --
427: -- raise error as FK does not relate to PK in PAY_ELEMENT_TYPES_F
428: -- table.
429: --
430: pqh_rer_shd.constraint_error('PQH_RATE_ELEMENT_RELATIONS_FK4');
431: --
432: end if;
433: --
434: close c1;

Line 513: pqh_rer_shd.constraint_error('PQH_RATE_ELEMENT_RELATIONS_FK5');

509: --
510: -- raise error as FK does not relate to PK in PAY_INPUT_VALUE_F
511: -- table.
512: --
513: pqh_rer_shd.constraint_error('PQH_RATE_ELEMENT_RELATIONS_FK5');
514: --
515: end if;
516: --
517: close c1;

Line 595: pqh_rer_shd.constraint_error('PQH_RATE_ELEMENT_RELATIONS_FK3');

591: --
592: -- raise error as FK does not relate to PK in HR_ALL_ORGANIZATION_UNITS
593: -- table.
594: --
595: pqh_rer_shd.constraint_error('PQH_RATE_ELEMENT_RELATIONS_FK3');
596: --
597: end if;
598: --
599: close c1;