APPS.PAY_SG_IRAS_AMEND_SETUP dependencies on PER_ASSIGNMENTS_F

Line 96: from per_assignments_f a,

92: c_start_person_id in per_all_people_f.person_id%type,
93: c_end_person_id in per_all_people_f.person_id%type )
94: is
95: select distinct a.assignment_id
96: from per_assignments_f a,
97: pay_payroll_actions pa
98: where pa.payroll_action_id = c_payroll_action_id
99: and a.person_id between c_start_person_id and c_end_person_id
100: and a.business_group_id = pa.business_group_id

Line 122: from per_assignments_f paf,

118: -- We'll do this because unless they have submitted an original, no need of an archive
119: ----------------------------------------------------------------------
120: and exists
121: ( select null
122: from per_assignments_f paf,
123: pay_assignment_actions mcl,
124: pay_payroll_actions mpl
125: where paf.assignment_id = a.assignment_id
126: and paf.assignment_id = mcl.assignment_id

Line 142: from per_assignments_f paf,

138: -- year and legal entity.
139: --------------------------------------------------------------------------------------------------------------------
140: and exists
141: ( select null
142: from per_assignments_f paf,
143: pay_assignment_actions pac,
144: pay_payroll_actions ppa
145: where paf.assignment_id = a.assignment_id
146: and paf.assignment_id = pac.assignment_id

Line 231: per_assignments_f paa,

227: fnd_date.date_to_canonical(pap.start_date), /* Bug# 3910804 */
228: paa.person_id,
229: pac.assignment_id
230: from pay_assignment_actions pac,
231: per_assignments_f paa,
232: per_people_f pap
233: where pac.assignment_action_id = c_assignment_action_id
234: and paa.assignment_id = pac.assignment_id
235: and paa.person_id = pap.person_id;