DBA Data[Home] [Help]

APPS.PAY_ISB_BUS dependencies on PER_BUSINESS_GROUPS

Line 237: from per_business_groups pbg

233: -- Declare cursor
234: --
235: cursor csr_sec_grp is
236: select pbg.security_group_id
237: from per_business_groups pbg
238: , pay_ie_social_benefits_f isb
239: , per_all_assignments_f paf
240: where isb.social_benefit_id = p_social_benefit_id
241: and pbg.business_group_id = paf.business_group_id

Line 299: from per_business_groups pbg

295: -- Declare cursor
296: --
297: cursor csr_leg_code is
298: select pbg.legislation_code
299: from per_business_groups pbg
300: , pay_ie_social_benefits_f isb
301: , per_all_assignments_f paf
302: where isb.social_benefit_id = p_social_benefit_id
303: and pbg.business_group_id = paf.business_group_id