DBA Data[Home] [Help]

APPS.IRC_IAS_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: , per_all_assignments_f asg
31: where pbg.business_group_id = asg.business_group_id
32: and asg.assignment_id = p_assignment_id ;
33: --

Line 87: from per_business_groups_perf pbg

83: -- Declare cursor
84: --
85: cursor csr_leg_code is
86: select pbg.legislation_code
87: from per_business_groups_perf pbg
88: , per_all_assignments_f asg
89: , irc_assignment_statuses ias
90: where pbg.business_group_id = asg.business_group_id
91: and asg.assignment_id = ias.assignment_id