APPS.PAY_AU_TFN_MAGTAPE dependencies on PAY_PAYROLL_ACTIONS

Line 63: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE,

59: -- for the archicve process.
60: ------------------------------------------------------------------------------+
61:
62: PROCEDURE range_code
63: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE,
64: p_sql out nocopy varchar2) IS
65:
66: BEGIN
67:

Line 74: ' pay_payroll_actions pa ' ||

70: /*Bug2920725 Corrected base tables to support security model*/
71:
72: p_sql := ' SELECT distinct p.person_id' ||
73: ' FROM per_people_f p,' ||
74: ' pay_payroll_actions pa ' ||
75: ' WHERE pa.payroll_action_id = :payroll_action_id' ||
76: ' AND p.business_group_id = pa.business_group_id' ||
77: ' ORDER BY p.person_id';
78:

Line 99: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE,

95: -- magtape once again.
96: ----------------------------------------------------------------------------+
97:
98: PROCEDURE assignment_action_code
99: (p_payroll_action_id in pay_payroll_actions.payroll_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:

Line 134: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE,

130: c_report_end_date BETWEEN paa.effective_start_date AND paa.effective_end_date
131: and condition
132: paa.effective_start_date between c_report_end_date - 13 and c_report_end_date */
133: CURSOR process_assignments
134: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE,
135: c_start_person_id in per_all_people_f.person_id%TYPE,
136: c_end_person_id in per_all_people_f.person_id%TYPE,
137: c_business_group_id in per_business_groups.business_group_id%TYPE,
138: c_legal_employer_id in hr_soft_coding_keyflex.segment1%TYPE,

Line 144: FROM pay_payroll_actions ppa

140: SELECT /*+ ORDERED */ paa.assignment_id,
141: decode(sign(nvl(pps.actual_termination_date,to_date('31/12/4712','DD/MM/YYYY')) - c_report_end_date),1,
142: null,pps.actual_termination_date) actual_termination_date,
143: peev.screen_entry_value tax_file_number
144: FROM pay_payroll_actions ppa
145: ,per_people_f pap
146: ,per_assignments_f paa
147: ,hr_soft_coding_keyflex hsc
148: ,per_periods_of_service pps

Line 227: FROM pay_payroll_actions ppa,

223: AND c_report_end_date BETWEEN pel.effective_start_date AND pel.effective_end_date
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))

Line 245: CURSOR c_get_parameters( c_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE) IS

241: ----------------------------------------------------------------------------------
242: /* Bug 2974527 - Changed the cursor to consider report end date -1 */
243: /* Bug 3229452 - Used fnd_date.canonical_to_date instead of to_date for selecting
244: report end date from ppa.legislative paramenters */
245: CURSOR c_get_parameters( c_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE) IS
246: SELECT
247: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',ppa.legislative_parameters),
248: pay_core_utils.get_parameter('LEGAL_EMPLOYER',ppa.legislative_parameters),
249: fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORT_END_DATE',ppa.legislative_parameters))-1

Line 250: FROM pay_payroll_actions ppa

246: SELECT
247: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',ppa.legislative_parameters),
248: pay_core_utils.get_parameter('LEGAL_EMPLOYER',ppa.legislative_parameters),
249: fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORT_END_DATE',ppa.legislative_parameters))-1
250: FROM pay_payroll_actions ppa
251: WHERE ppa.payroll_action_id = c_payroll_action_id;
252:
253: l_business_group_id per_business_groups.business_group_id%TYPE;
254: l_legal_employer_id hr_soft_coding_keyflex.segment1%TYPE;

Line 324: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE) IS

320: -- eligible employees to print on the magtape.
321: -----------------------------------------------------------------------------+
322:
323: PROCEDURE initialization_code
324: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE) IS
325:
326:
327: ----------------------------------------------------------------------------------
328: -- CURSOR to FETCH the passed parameters to the magtape process

Line 333: CURSOR c_get_parameters( c_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE) IS

329: ----------------------------------------------------------------------------------
330: /* Bug 2974527 - Changed the cursor to consider report end date -1 */
331: /* Bug 3229452 - Used fnd_date.canonical_to_date instead of to_date for selecting
332: report end date from ppa.legislative paramenters */
333: CURSOR c_get_parameters( c_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE) IS
334: SELECT
335: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',ppa.legislative_parameters),
336: pay_core_utils.get_parameter('LEGAL_EMPLOYER',ppa.legislative_parameters),
337: fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORT_END_DATE',ppa.legislative_parameters))-1

Line 338: FROM pay_payroll_actions ppa

334: SELECT
335: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',ppa.legislative_parameters),
336: pay_core_utils.get_parameter('LEGAL_EMPLOYER',ppa.legislative_parameters),
337: fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORT_END_DATE',ppa.legislative_parameters))-1
338: FROM pay_payroll_actions ppa
339: WHERE ppa.payroll_action_id = c_payroll_action_id;
340:
341: l_business_group_id per_business_groups.business_group_id%TYPE;
342: l_legal_employer_id hr_soft_coding_keyflex.segment1%TYPE;