APPS.IRC_IAS_BUS dependencies on PER_ALL_ASSIGNMENTS_F

Line 30: , per_all_assignments_f asg

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: --
34: -- Declare local variables

Line 88: , per_all_assignments_f asg

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
92: and ias.assignment_status_id = p_assignment_status_id ;

Line 202: -- per_all_assignments_f.

198: -- {Start Of Comments}
199: --
200: -- Description:
201: -- This procedure is used to ensure that assignment Id exists in table
202: -- per_all_assignments_f.
203: --
204: -- Pre Conditions:
205: -- assignment Id should exist in the table.
206: --

Line 229: from per_all_assignments_f

225: l_assignment_id irc_assignment_statuses.assignment_id%type ;
226: --
227: cursor csr_applicant_assignment is
228: select 1
229: from per_all_assignments_f
230: where assignment_id = p_assignment_id;
231: --
232: begin
233: --