DBA Data[Home] [Help]

APPS.BEN_PQC_BUS dependencies on PER_BUSINESS_GROUPS

Line 28: from per_business_groups pbg

24: -- Declare cursor
25: --
26: cursor csr_sec_grp is
27: select pbg.security_group_id
28: from per_business_groups pbg
29: , ben_prtt_rmt_rqst_ctfn_prvdd_f pqc
30: where pqc.prtt_rmt_rqst_ctfn_prvdd_id = p_prtt_rmt_rqst_ctfn_prvdd_id
31: and pbg.business_group_id = pqc.business_group_id;
32: --

Line 88: from per_business_groups pbg

84: -- Declare cursor
85: --
86: cursor csr_leg_code is
87: select pbg.legislation_code
88: from per_business_groups pbg
89: , ben_prtt_rmt_rqst_ctfn_prvdd_f pqc
90: where pqc.prtt_rmt_rqst_ctfn_prvdd_id = p_prtt_rmt_rqst_ctfn_prvdd_id
91: and pbg.business_group_id (+) = pqc.business_group_id;
92: --