APPS.PAY_SG_IRAS_AMEND_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 85: select pay_assignment_actions_s.nextval

81: ----------------------------------------------------------------------------
82: -- Cursor Next Assignment Action
83: ----------------------------------------------------------------------------
84: cursor next_action_id is
85: select pay_assignment_actions_s.nextval
86: from dual;
87: ----------------------------------------------------------------------------
88: -- Filters Assignments to be processed.
89: ----------------------------------------------------------------------------

Line 123: pay_assignment_actions mcl,

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

Line 143: pay_assignment_actions pac,

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

Line 211: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type

207: ------------------------------------------------------------------------
208: -- Archives Person details for the processing Assignment
209: ------------------------------------------------------------------------
210: procedure archive_code
211: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type
212: , p_effective_date in date )
213: is
214: v_national_identifier per_all_people_f.national_identifier%type;
215: v_start_date varchar2(50); /* Bug# 3910804 */

Line 218: v_setup_action pay_assignment_actions.payroll_action_id%type;

214: v_national_identifier per_all_people_f.national_identifier%type;
215: v_start_date varchar2(50); /* Bug# 3910804 */
216: v_person_id per_all_people_f.person_id%type;
217: v_assignment_id per_all_assignments_f.assignment_id%type;
218: v_setup_action pay_assignment_actions.payroll_action_id%type;
219: ------------------------------------------------------------------------
220: -- Get Person Details
221: -- Bug 3910804 - Selected canonical format of person start date
222: ------------------------------------------------------------------------

Line 224: ( c_assignment_action_id pay_assignment_actions.assignment_action_id%type )

220: -- Get Person Details
221: -- Bug 3910804 - Selected canonical format of person start date
222: ------------------------------------------------------------------------
223: cursor get_details
224: ( c_assignment_action_id pay_assignment_actions.assignment_action_id%type )
225: is
226: select nvl(pap.national_identifier,per_information12),
227: fnd_date.date_to_canonical(pap.start_date), /* Bug# 3910804 */
228: paa.person_id,

Line 230: from pay_assignment_actions pac,

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

Line 246: from pay_assignment_actions

242: -- Get setup action id
243: -------------------------------------------------------------------
244: select payroll_action_id
245: into v_setup_action
246: from pay_assignment_actions
247: where assignment_action_id = p_assignment_action_id ;
248: --
249: open get_details ( p_assignment_action_id );
250: fetch get_details into v_national_identifier,