APPS.PAY_SG_IRAS_ARCHIVE dependencies on PER_ALL_ASSIGNMENTS_F

Line 137: -- p_assignment_id in per_all_assignments_f.assignment_id%type,

133: --
134: procedure archive_emp_details
135: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
136: p_person_id in per_all_people_f.person_id%type,
137: -- p_assignment_id in per_all_assignments_f.assignment_id%type,
138: p_legal_entity_id in hr_organization_units.organization_id%type, /* Bug 13786754*/
139: p_basis_start in date,
140: p_basis_end in date );
141: --

Line 172: p_assignment_id in per_all_assignments_f.assignment_id%type,

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

Line 183: p_assignment_id in per_all_assignments_f.assignment_id%type,

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

Line 194: p_assignment_id in per_all_assignments_f.assignment_id%type,

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

Line 215: p_assignment_id in per_all_assignments_f.assignment_id%type,

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

Line 375: from per_all_assignments_f paa,

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

Line 398: from per_all_assignments_f paa,

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