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 136: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE,

132: paa.effective_start_date between c_report_end_date - 13 and c_report_end_date */
133: /* Bug 8352719 - Removed NULL termination date check at 2 places and a redundant join*/
134: /* Bug 12377615- Changed to STAR_TRANSFORMATION hint from ORDERED */
135: CURSOR process_assignments
136: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE,
137: c_start_person_id in per_all_people_f.person_id%TYPE,
138: c_end_person_id in per_all_people_f.person_id%TYPE,
139: c_business_group_id in per_business_groups.business_group_id%TYPE,
140: c_legal_employer_id in hr_soft_coding_keyflex.segment1%TYPE,

Line 146: FROM pay_payroll_actions ppa

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

Line 217: FROM pay_payroll_actions ppa,

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

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

231: ----------------------------------------------------------------------------------
232: /* Bug 2974527 - Changed the cursor to consider report end date -1 */
233: /* Bug 3229452 - Used fnd_date.canonical_to_date instead of to_date for selecting
234: report end date from ppa.legislative paramenters */
235: CURSOR c_get_parameters( c_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE) IS
236: SELECT
237: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',ppa.legislative_parameters),
238: pay_core_utils.get_parameter('LEGAL_EMPLOYER',ppa.legislative_parameters),
239: fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORT_END_DATE',ppa.legislative_parameters))-1

Line 240: FROM pay_payroll_actions ppa

236: SELECT
237: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',ppa.legislative_parameters),
238: pay_core_utils.get_parameter('LEGAL_EMPLOYER',ppa.legislative_parameters),
239: fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORT_END_DATE',ppa.legislative_parameters))-1
240: FROM pay_payroll_actions ppa
241: WHERE ppa.payroll_action_id = c_payroll_action_id;
242:
243: l_business_group_id per_business_groups.business_group_id%TYPE;
244: l_legal_employer_id hr_soft_coding_keyflex.segment1%TYPE;

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

310: -- eligible employees to print on the magtape.
311: -----------------------------------------------------------------------------+
312:
313: PROCEDURE initialization_code
314: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE) IS
315:
316:
317: ----------------------------------------------------------------------------------
318: -- CURSOR to FETCH the passed parameters to the magtape process

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

319: ----------------------------------------------------------------------------------
320: /* Bug 2974527 - Changed the cursor to consider report end date -1 */
321: /* Bug 3229452 - Used fnd_date.canonical_to_date instead of to_date for selecting
322: report end date from ppa.legislative paramenters */
323: CURSOR c_get_parameters( c_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE) IS
324: SELECT
325: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',ppa.legislative_parameters),
326: pay_core_utils.get_parameter('LEGAL_EMPLOYER',ppa.legislative_parameters),
327: fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORT_END_DATE',ppa.legislative_parameters))-1

Line 328: FROM pay_payroll_actions ppa

324: SELECT
325: pay_core_utils.get_parameter('BUSINESS_GROUP_ID',ppa.legislative_parameters),
326: pay_core_utils.get_parameter('LEGAL_EMPLOYER',ppa.legislative_parameters),
327: fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORT_END_DATE',ppa.legislative_parameters))-1
328: FROM pay_payroll_actions ppa
329: WHERE ppa.payroll_action_id = c_payroll_action_id;
330:
331: l_business_group_id per_business_groups.business_group_id%TYPE;
332: l_legal_employer_id hr_soft_coding_keyflex.segment1%TYPE;