APPS.PAY_SG_IRAS_ARCHIVE_SETUP dependencies on PAY_ASSIGNMENT_ACTIONS

Line 50: v_next_action_id pay_assignment_actions.assignment_action_id%type;

46: , p_start_person_id in per_all_people_f.person_id%type
47: , p_end_person_id in per_all_people_f.person_id%type
48: , p_chunk in number )
49: is
50: v_next_action_id pay_assignment_actions.assignment_action_id%type;
51: v_effective_date date;
52: v_business_group_id number;
53: v_basis_start date;
54: v_basis_end date;

Line 81: select pay_assignment_actions_s.nextval

77: ----------------------------------------------------------------------------
78: -- Cursor Next Assignment Action
79: ----------------------------------------------------------------------------
80: cursor next_action_id is
81: select pay_assignment_actions_s.nextval
82: from dual;
83: ----------------------------------------------------------------------------
84: -- Filters Assignments to be processed.
85: ----------------------------------------------------------------------------

Line 116: pay_assignment_actions mcl,

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
120: and mpl.payroll_action_id = mcl.payroll_action_id

Line 136: pay_assignment_actions pac,

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
140: and pac.tax_unit_id = v_legal_entity_id

Line 202: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type

198: ------------------------------------------------------------------------
199: -- Archives Person details for the processing Assignment
200: ------------------------------------------------------------------------
201: procedure archive_code
202: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type
203: , p_effective_date in date )
204: is
205: v_national_identifier per_all_people_f.national_identifier%type;
206: v_start_date varchar2(50); /* Bug# 3910804 */

Line 209: v_setup_action pay_assignment_actions.payroll_action_id%type;

205: v_national_identifier per_all_people_f.national_identifier%type;
206: v_start_date varchar2(50); /* Bug# 3910804 */
207: v_person_id per_all_people_f.person_id%type;
208: v_assignment_id per_all_assignments_f.assignment_id%type;
209: v_setup_action pay_assignment_actions.payroll_action_id%type;
210: ------------------------------------------------------------------------
211: -- Get Person Details
212: -- Bug 3910804 - Selected canonical format of person start date
213: ------------------------------------------------------------------------

Line 215: ( c_assignment_action_id pay_assignment_actions.assignment_action_id%type )

211: -- Get Person Details
212: -- Bug 3910804 - Selected canonical format of person start date
213: ------------------------------------------------------------------------
214: cursor get_details
215: ( c_assignment_action_id pay_assignment_actions.assignment_action_id%type )
216: is
217: select nvl(pap.national_identifier,per_information12),
218: fnd_date.date_to_canonical(pap.start_date), /* Bug# 3910804 */
219: paa.person_id,

Line 221: from pay_assignment_actions pac,

217: select nvl(pap.national_identifier,per_information12),
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

Line 237: from pay_assignment_actions

233: -- Get setup action id
234: -------------------------------------------------------------------
235: select payroll_action_id
236: into v_setup_action
237: from pay_assignment_actions
238: where assignment_action_id = p_assignment_action_id ;
239: --
240: open get_details ( p_assignment_action_id );
241: fetch get_details into v_national_identifier,