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 228: pay_assignment_actions pac

224: AND c_report_end_date BETWEEN piv.effective_start_date AND piv.effective_end_date
225: AND NOT EXISTS
226: (SELECT 1
227: FROM pay_payroll_actions ppa,
228: pay_assignment_actions pac
229: WHERE pac.assignment_id = paa.assignment_id
230: AND ppa.payroll_Action_id = pac.payroll_action_id
231: AND fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORT_END_DATE',ppa.legislative_parameters))
232: BETWEEN c_report_end_date - 13 AND c_report_end_date

Line 258: SELECT pay_assignment_actions_s.nextval

254: l_legal_employer_id hr_soft_coding_keyflex.segment1%TYPE;
255: l_report_end_date date;
256:
257: CURSOR next_action_id IS
258: SELECT pay_assignment_actions_s.nextval
259: FROM dual;
260:
261: BEGIN
262:

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

381: -- any data here, so thIS IS null.
382: -----------------------------------------------------------------------------+
383:
384: PROCEDURE archive_code
385: (p_payroll_action_id in pay_assignment_actions.payroll_action_id%TYPE,
386: p_effective_date in date) IS
387:
388: BEGIN
389: hr_utility.set_location('Start of archive_code',8);