APPS.PAY_SG_IRAS_ARCHIVE dependencies on PER_ALL_ASSIGNMENTS_F

Line 170: p_assignment_id in per_all_assignments_f.assignment_id%type,

166: --------------------------------------------------------------------------
167: procedure archive_assignment_eits
168: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
169: p_person_id in per_all_people_f.person_id%type,
170: p_assignment_id in per_all_assignments_f.assignment_id%type,
171: p_legal_entity_id in hr_organization_units.organization_id%type,
172: p_basis_start in date,
173: p_basis_end in date );
174: --

Line 181: p_assignment_id in per_all_assignments_f.assignment_id%type,

177: --------------------------------------------------------------------------
178: procedure archive_ass_bonus_date_eits
179: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
180: p_person_id in per_all_people_f.person_id%type,
181: p_assignment_id in per_all_assignments_f.assignment_id%type,
182: p_legal_entity_id in hr_organization_units.organization_id%type,
183: p_basis_start in date,
184: p_basis_end in date );
185: --

Line 192: p_assignment_id in per_all_assignments_f.assignment_id%type,

188: --------------------------------------------------------------------------
189: procedure archive_ass_payment_method
190: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
191: p_person_id in per_all_people_f.person_id%type,
192: p_assignment_id in per_all_assignments_f.assignment_id%type,
193: p_legal_entity_id in hr_organization_units.organization_id%type,
194: p_basis_start in date,
195: p_basis_end in date);
196: --

Line 213: p_assignment_id in per_all_assignments_f.assignment_id%type,

209: --------------------------------------------------------------------------
210: procedure archive_job_designation
211: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
212: p_person_id in per_all_people_f.person_id%type,
213: p_assignment_id in per_all_assignments_f.assignment_id%type,
214: p_legal_entity_id in hr_organization_units.organization_id%type,
215: p_basis_start in date,
216: p_basis_end in date,
217: p_er_designation_type in hr_organization_information.org_information17%type,

Line 373: from per_all_assignments_f paa,

369: 'PERSON_ID=P',
370: to_char(paa.person_id) person_id,
371: 'ASSIGNMENT_NUMBER=P',
372: paa.assignment_number assignment_number
373: from per_all_assignments_f paa,
374: pay_payroll_actions ppa,
375: pay_assignment_actions pac,
376: ff_archive_items fai,
377: ff_archive_item_contexts ac2

Line 396: from per_all_assignments_f paa,

392: 'TAX_UNIT_ID=C',
393: to_number(ac2.context) tax_unit_id,
394: 'BASIS_YEAR=P',
395: pay_core_utils.get_parameter('BASIS_YEAR', ppa.legislative_parameters) basis_year
396: from per_all_assignments_f paa,
397: pay_payroll_actions ppa,
398: pay_assignment_actions pac,
399: ff_archive_items fai,
400: ff_archive_item_contexts ac2