APPS.PAY_AU_TFN_MAGTAPE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 104: v_next_action_id pay_assignment_actions.assignment_action_id%TYPE;

100: p_start_person_id in per_all_people_f.person_id%TYPE,
101: p_END_person_id in per_all_people_f.person_id%TYPE,
102: p_chunk in number) IS
103:
104: v_next_action_id pay_assignment_actions.assignment_action_id%TYPE;
105: v_run_action_id pay_assignment_actions.assignment_action_id%TYPE;
106: p_assignment_id pay_assignment_actions.assignment_id%TYPE;
107: ps_report_id pay_assignment_actions.assignment_action_id%TYPE;
108:

Line 105: v_run_action_id pay_assignment_actions.assignment_action_id%TYPE;

101: p_END_person_id in per_all_people_f.person_id%TYPE,
102: p_chunk in number) IS
103:
104: v_next_action_id pay_assignment_actions.assignment_action_id%TYPE;
105: v_run_action_id pay_assignment_actions.assignment_action_id%TYPE;
106: p_assignment_id pay_assignment_actions.assignment_id%TYPE;
107: ps_report_id pay_assignment_actions.assignment_action_id%TYPE;
108:
109:

Line 106: p_assignment_id pay_assignment_actions.assignment_id%TYPE;

102: p_chunk in number) IS
103:
104: v_next_action_id pay_assignment_actions.assignment_action_id%TYPE;
105: v_run_action_id pay_assignment_actions.assignment_action_id%TYPE;
106: p_assignment_id pay_assignment_actions.assignment_id%TYPE;
107: ps_report_id pay_assignment_actions.assignment_action_id%TYPE;
108:
109:
110: ----------------------------------------------------------------------------------

Line 107: ps_report_id pay_assignment_actions.assignment_action_id%TYPE;

103:
104: v_next_action_id pay_assignment_actions.assignment_action_id%TYPE;
105: v_run_action_id pay_assignment_actions.assignment_action_id%TYPE;
106: p_assignment_id pay_assignment_actions.assignment_id%TYPE;
107: ps_report_id pay_assignment_actions.assignment_action_id%TYPE;
108:
109:
110: ----------------------------------------------------------------------------------
111: -- Cursor to restrict the assignments to be processed by the magtape.

Line 218: pay_assignment_actions pac

214: AND c_report_end_date BETWEEN piv.effective_start_date AND piv.effective_end_date
215: AND NOT EXISTS
216: (SELECT 1
217: FROM pay_payroll_actions ppa,
218: pay_assignment_actions pac
219: WHERE pac.assignment_id = paa.assignment_id
220: AND ppa.payroll_Action_id = pac.payroll_action_id
221: AND fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORT_END_DATE',ppa.legislative_parameters))
222: BETWEEN c_report_end_date - 13 AND c_report_end_date

Line 248: SELECT pay_assignment_actions_s.nextval

244: l_legal_employer_id hr_soft_coding_keyflex.segment1%TYPE;
245: l_report_end_date date;
246:
247: CURSOR next_action_id IS
248: SELECT pay_assignment_actions_s.nextval
249: FROM dual;
250:
251: BEGIN
252:

Line 375: (p_payroll_action_id in pay_assignment_actions.payroll_action_id%TYPE,

371: -- any data here, so thIS IS null.
372: -----------------------------------------------------------------------------+
373:
374: PROCEDURE archive_code
375: (p_payroll_action_id in pay_assignment_actions.payroll_action_id%TYPE,
376: p_effective_date in date) IS
377:
378: BEGIN
379: hr_utility.set_location('Start of archive_code',8);