DBA Data[Home] [Help]

APPS.PQH_VLP_BUS dependencies on PER_BUSINESS_GROUPS

Line 29: from per_business_groups pbg

25: -- Declare cursor
26: --
27: cursor csr_sec_grp is
28: select pbg.security_group_id
29: from per_business_groups pbg
30: , pqh_fr_validation_periods vlp
31: , pqh_fr_validations vld
32: where vld.validation_id = vlp.validation_id
33: and vlp.validation_period_id = p_validation_period_id

Line 95: from per_business_groups pbg

91: -- Declare cursor
92: --
93: cursor csr_leg_code is
94: select pbg.legislation_code
95: from per_business_groups pbg
96: , pqh_fr_validation_periods vlp
97: , pqh_Fr_validations vld
98: where vld.validation_id = vlp.validation_id
99: and vlp.validation_period_id = p_validation_period_id