DBA Data[Home] [Help]

APPS.PQH_CRL_BUS dependencies on PER_BUSINESS_GROUPS_PERF

Line 31: from per_business_groups_perf pbg

27: --
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_criteria_rate_defn_tl crl
33: , pqh_criteria_rate_defn crd
34: where crl.criteria_rate_defn_id = p_criteria_rate_defn_id
35: and crd.criteria_rate_defn_id = crl.criteria_rate_defn_id

Line 104: -- pqh_criteria_rate_defn_tl and PER_BUSINESS_GROUPS_PERF

100: --
101: -- Declare cursor
102: --
103: -- EDIT_HERE In the following cursor statement add join(s) between
104: -- pqh_criteria_rate_defn_tl and PER_BUSINESS_GROUPS_PERF
105: -- so that the legislation_code for
106: -- the current business group context can be derived.
107: -- Remove this comment when the edit has been completed.
108: cursor csr_leg_code is

Line 110: from per_business_groups_perf pbg

106: -- the current business group context can be derived.
107: -- Remove this comment when the edit has been completed.
108: cursor csr_leg_code is
109: select pbg.legislation_code
110: from per_business_groups_perf pbg
111: , pqh_criteria_rate_defn_tl crl
112: -- , EDIT_HERE table_name(s) 333
113: where crl.criteria_rate_defn_id = p_criteria_rate_defn_id
114: and crl.language = p_language;