DBA Data[Home] [Help]

APPS.PQH_TJR_BUS dependencies on PQH_TXN_JOB_REQUIREMENTS

Line 29: , pqh_txn_job_requirements tjr

25: --
26: cursor csr_sec_grp is
27: select pbg.security_group_id
28: from per_business_groups pbg
29: , pqh_txn_job_requirements tjr
30: where tjr.txn_job_requirement_id = p_txn_job_requirement_id
31: and pbg.business_group_id = tjr.business_group_id;
32: --
33: -- Declare local variables

Line 89: , pqh_txn_job_requirements tjr

85: --
86: cursor csr_leg_code is
87: select pbg.legislation_code
88: from per_business_groups pbg
89: , pqh_txn_job_requirements tjr
90: where tjr.txn_job_requirement_id = p_txn_job_requirement_id
91: and pbg.business_group_id = tjr.business_group_id;
92: --
93: -- Declare local variables