DBA Data[Home] [Help]

APPS.PQH_CPD_BUS dependencies on PQH_CORPS_DEFINITIONS

Line 32: , pqh_corps_definitions cpd

28: cursor csr_sec_grp is
29: select pbg.security_group_id,
30: pbg.legislation_code
31: from per_business_groups_perf pbg
32: , pqh_corps_definitions cpd
33: where cpd.corps_definition_id = p_corps_definition_id
34: and pbg.business_group_id = cpd.business_group_id;
35: --
36: -- Declare local variables

Line 107: , pqh_corps_definitions cpd

103: --
104: cursor csr_leg_code is
105: select pbg.legislation_code
106: from per_business_groups_perf pbg
107: , pqh_corps_definitions cpd
108: where cpd.corps_definition_id = p_corps_definition_id
109: and pbg.business_group_id = cpd.business_group_id;
110: --
111: -- Declare local variables

Line 422: FROM pqh_corps_definitions

418: -- Declare cursor
419: --
420: CURSOR csr_cpd_name is
421: SELECT 'X'
422: FROM pqh_corps_definitions
423: WHERE name = p_name
424: AND corps_definition_id <> nvl(p_corps_definition_id,-1)
425: AND business_group_id = p_business_group_id;
426: --