APPS.PAY_SG_IRAS_ARCHIVE_SETUP dependencies on PER_ASSIGNMENTS_F

Line 92: from per_assignments_f a,

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

Line 115: from per_assignments_f paf,

111: -- If they want to re-archive a person, they must ROLLBACK the magtape first
112: ----------------------------------------------------------------------
113: and not exists
114: ( select null
115: from per_assignments_f paf,
116: pay_assignment_actions mcl,
117: pay_payroll_actions mpl
118: where paf.assignment_id = a.assignment_id
119: and paf.assignment_id = mcl.assignment_id

Line 135: from per_assignments_f paf,

131: -- year and legal entity.
132: --------------------------------------------------------------------------------------------------------------------
133: and exists
134: ( select null
135: from per_assignments_f paf,
136: pay_assignment_actions pac,
137: pay_payroll_actions ppa
138: where paf.assignment_id = a.assignment_id
139: and paf.assignment_id = pac.assignment_id

Line 222: per_assignments_f paa,

218: fnd_date.date_to_canonical(pap.start_date), /* Bug# 3910804 */
219: paa.person_id,
220: pac.assignment_id
221: from pay_assignment_actions pac,
222: per_assignments_f paa,
223: per_people_f pap
224: where pac.assignment_action_id = c_assignment_action_id
225: and paa.assignment_id = pac.assignment_id
226: and paa.person_id = pap.person_id;