eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_AU_PAYMENT_SUMMARY_MAGTAPE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 107: v_next_action_id pay_assignment_actions.assignment_action_id%type;

103: p_start_person_id in per_all_people_f.person_id%type,
104: p_end_person_id in per_all_people_f.person_id%type,
105: p_chunk in number) is
106:
107: v_next_action_id pay_assignment_actions.assignment_action_id%type;
108: v_run_action_id pay_assignment_actions.assignment_action_id%type;
109: p_assignment_id pay_assignment_Actions.assignment_id%type;
110: ps_report_id pay_assignment_actions.assignment_action_id%type;
111: l_payment_summary_type varchar2(5) := 'O'; /* bug 6630375 */

Line 108: v_run_action_id pay_assignment_actions.assignment_action_id%type;

104: p_end_person_id in per_all_people_f.person_id%type,
105: p_chunk in number) is
106:
107: v_next_action_id pay_assignment_actions.assignment_action_id%type;
108: v_run_action_id pay_assignment_actions.assignment_action_id%type;
109: p_assignment_id pay_assignment_Actions.assignment_id%type;
110: ps_report_id pay_assignment_actions.assignment_action_id%type;
111: l_payment_summary_type varchar2(5) := 'O'; /* bug 6630375 */
112:

Line 109: p_assignment_id pay_assignment_Actions.assignment_id%type;

105: p_chunk in number) is
106:
107: v_next_action_id pay_assignment_actions.assignment_action_id%type;
108: v_run_action_id pay_assignment_actions.assignment_action_id%type;
109: p_assignment_id pay_assignment_Actions.assignment_id%type;
110: ps_report_id pay_assignment_actions.assignment_action_id%type;
111: l_payment_summary_type varchar2(5) := 'O'; /* bug 6630375 */
112:
113: ------start of Bug3132178-----------------------------------------------------

Line 110: ps_report_id pay_assignment_actions.assignment_action_id%type;

106:
107: v_next_action_id pay_assignment_actions.assignment_action_id%type;
108: v_run_action_id pay_assignment_actions.assignment_action_id%type;
109: p_assignment_id pay_assignment_Actions.assignment_id%type;
110: ps_report_id pay_assignment_actions.assignment_action_id%type;
111: l_payment_summary_type varchar2(5) := 'O'; /* bug 6630375 */
112:
113: ------start of Bug3132178-----------------------------------------------------
114: l_testing_flag varchar2(5):='N';

Line 135: FROM pay_assignment_actions paa,

131: IS
132: SELECT DISTINCT 'ASSIGNMENT_ACTION_ID=C',
133: paa.assignment_action_id ps_report_id,
134: paa.assignment_id
135: FROM pay_assignment_actions paa,
136: per_assignments_f a
137: WHERE paa.payroll_action_id = c_payroll_action_id
138: AND paa.action_status = 'C'
139: AND a.assignment_id = paa.assignment_id

Line 153: FROM pay_assignment_actions paa,

149: IS
150: SELECT DISTINCT 'ASSIGNMENT_ACTION_ID=C',
151: paa.assignment_action_id ps_report_id,
152: paa.assignment_id
153: FROM pay_assignment_actions paa,
154: per_assignments_f a,
155: pay_population_ranges ppr
156: WHERE paa.payroll_action_id = c_payroll_action_id
157: AND ppr.payroll_action_id = p_payroll_action_id

Line 173: SELECT /*+ INDEX (apac PAY_ASSIGNMENT_ACTIONS_N50)

169: CURSOR process_assignments
170: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
171: c_start_person_id in per_all_people_f.person_id%type,
172: c_end_person_id in per_all_people_f.person_id%type) is
173: SELECT /*+ INDEX (apac PAY_ASSIGNMENT_ACTIONS_N50)
174: INDEX (ppac PAY_ASSIGNMENT_ACTIONS_PK)
175: INDEX(mpa PAY_PAYROLL_ACTIONS_PK)
176: INDEX(ppai PAY_ACTION_INTERLOCKS_FK2)
177: INDEX (p PER_PEOPLE_F_PK)

Line 174: INDEX (ppac PAY_ASSIGNMENT_ACTIONS_PK)

170: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
171: c_start_person_id in per_all_people_f.person_id%type,
172: c_end_person_id in per_all_people_f.person_id%type) is
173: SELECT /*+ INDEX (apac PAY_ASSIGNMENT_ACTIONS_N50)
174: INDEX (ppac PAY_ASSIGNMENT_ACTIONS_PK)
175: INDEX(mpa PAY_PAYROLL_ACTIONS_PK)
176: INDEX(ppai PAY_ACTION_INTERLOCKS_FK2)
177: INDEX (p PER_PEOPLE_F_PK)
178: INDEX(a PER_ASSIGNMENTS_F_PK) */

Line 186: pay_assignment_actions apac,

182: FROM pay_payroll_actions mpa,
183: per_people_f p,
184: per_assignments_f a,
185: pay_payroll_actions apa,
186: pay_assignment_actions apac,
187: pay_payroll_actions ppa,
188: pay_assignment_actions ppac,
189: pay_action_interlocks ppai
190: WHERE mpa.payroll_action_id =c_payroll_action_id

Line 188: pay_assignment_actions ppac,

184: per_assignments_f a,
185: pay_payroll_actions apa,
186: pay_assignment_actions apac,
187: pay_payroll_actions ppa,
188: pay_assignment_actions ppac,
189: pay_action_interlocks ppai
190: WHERE mpa.payroll_action_id =c_payroll_action_id
191: AND p.person_id = a.person_id
192: AND p.person_id BETWEEN c_start_person_id AND c_end_person_id

Line 214: pay_assignment_actions paa1,

210: pay_core_utils.get_parameter('FINANCIAL_YEAR',mpa.legislative_parameters)
211: AND NOT EXISTS /* 5471093 */
212: (SELECT /*+ ORDERED */ locked_action_id
213: FROM pay_action_interlocks pail,
214: pay_assignment_actions paa1,
215: pay_payroll_actions paas
216: WHERE paas.action_type='X'
217: and paas.action_status='C'
218: AND paas.report_type='AU_PS_DATA_FILE'

Line 242: INDEX (apac PAY_ASSIGNMENT_ACTIONS_N51)

238: INDEX (ppr PAY_POPULATION_RANGES_N4)
239: INDEX (p PER_PEOPLE_F_PK)
240: INDEX (apa PAY_PAYROLL_ACTIONS_N52)
241: INDEX (a PER_ASSIGNMENTS_F_N12)
242: INDEX (apac PAY_ASSIGNMENT_ACTIONS_N51)
243: INDEX (ppai PAY_ACTION_INTERLOCKS_FK2)
244: INDEX (ppac PAY_ASSIGNMENT_ACTIONS_PK)
245: */
246: DISTINCT 'ASSIGNMENT_ACTION_ID=C',

Line 244: INDEX (ppac PAY_ASSIGNMENT_ACTIONS_PK)

240: INDEX (apa PAY_PAYROLL_ACTIONS_N52)
241: INDEX (a PER_ASSIGNMENTS_F_N12)
242: INDEX (apac PAY_ASSIGNMENT_ACTIONS_N51)
243: INDEX (ppai PAY_ACTION_INTERLOCKS_FK2)
244: INDEX (ppac PAY_ASSIGNMENT_ACTIONS_PK)
245: */
246: DISTINCT 'ASSIGNMENT_ACTION_ID=C',
247: ppac.assignment_action_id ps_report_id,
248: ppac.assignment_id

Line 254: pay_assignment_actions apac,

250: pay_population_ranges ppr,
251: per_people_f p,
252: per_assignments_f a,
253: pay_payroll_actions apa,
254: pay_assignment_actions apac,
255: pay_payroll_actions ppa,
256: pay_assignment_actions ppac,
257: pay_action_interlocks ppai
258: WHERE mpa.payroll_action_id = c_payroll_action_id

Line 256: pay_assignment_actions ppac,

252: per_assignments_f a,
253: pay_payroll_actions apa,
254: pay_assignment_actions apac,
255: pay_payroll_actions ppa,
256: pay_assignment_actions ppac,
257: pay_action_interlocks ppai
258: WHERE mpa.payroll_action_id = c_payroll_action_id
259: AND ppr.payroll_action_id = mpa.payroll_action_id
260: AND p.person_id = ppr.person_id

Line 287: pay_assignment_actions paa1,

283: pay_core_utils.get_parameter('FINANCIAL_YEAR',mpa.legislative_parameters)
284: AND NOT EXISTS /* 5471093 */
285: (SELECT locked_action_id
286: FROM pay_action_interlocks pail,
287: pay_assignment_actions paa1,
288: pay_payroll_actions paas
289: WHERE paas.report_type='AU_PS_DATA_FILE'
290: AND paas.report_qualifier = 'AU'
291: AND paas.report_category = 'REPORT'

Line 307: FROM pay_assignment_actions paa,

303: IS
304: SELECT DISTINCT 'ASSIGNMENT_ACTION_ID=C',
305: paa.assignment_action_id ps_report_id,
306: paa.assignment_id
307: FROM pay_assignment_actions paa,
308: per_assignments_f a,
309: pay_payroll_actions ppa
310: WHERE ppa.payroll_action_id = c_payroll_action_id
311: AND ppa.payroll_action_id = paa.payroll_action_id

Line 329: FROM pay_assignment_actions paa,

325: IS
326: SELECT DISTINCT 'ASSIGNMENT_ACTION_ID=C',
327: paa.assignment_action_id ps_report_id,
328: paa.assignment_id
329: FROM pay_assignment_actions paa,
330: per_assignments_f a,
331: pay_population_ranges ppr
332: WHERE paa.payroll_action_id = c_payroll_action_id
333: AND ppr.payroll_action_id = p_payroll_action_id

Line 347: SELECT /*+ INDEX (apac PAY_ASSIGNMENT_ACTIONS_N50)

343: CURSOR process_assignments_amend /* bug 6630375 */
344: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
345: c_start_person_id in per_all_people_f.person_id%type,
346: c_end_person_id in per_all_people_f.person_id%type) is
347: SELECT /*+ INDEX (apac PAY_ASSIGNMENT_ACTIONS_N50)
348: INDEX (ppac PAY_ASSIGNMENT_ACTIONS_PK)
349: INDEX(mpa PAY_PAYROLL_ACTIONS_PK)
350: INDEX(ppai PAY_ACTION_INTERLOCKS_FK2)
351: INDEX (p PER_PEOPLE_F_PK)

Line 348: INDEX (ppac PAY_ASSIGNMENT_ACTIONS_PK)

344: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
345: c_start_person_id in per_all_people_f.person_id%type,
346: c_end_person_id in per_all_people_f.person_id%type) is
347: SELECT /*+ INDEX (apac PAY_ASSIGNMENT_ACTIONS_N50)
348: INDEX (ppac PAY_ASSIGNMENT_ACTIONS_PK)
349: INDEX(mpa PAY_PAYROLL_ACTIONS_PK)
350: INDEX(ppai PAY_ACTION_INTERLOCKS_FK2)
351: INDEX (p PER_PEOPLE_F_PK)
352: INDEX(a PER_ASSIGNMENTS_F_PK) */

Line 360: pay_assignment_actions apac,

356: FROM pay_payroll_actions mpa,
357: per_people_f p,
358: per_assignments_f a,
359: pay_payroll_actions apa,
360: pay_assignment_actions apac,
361: pay_payroll_actions ppa,
362: pay_assignment_actions ppac,
363: pay_action_interlocks ppai
364: WHERE mpa.payroll_action_id =c_payroll_action_id

Line 362: pay_assignment_actions ppac,

358: per_assignments_f a,
359: pay_payroll_actions apa,
360: pay_assignment_actions apac,
361: pay_payroll_actions ppa,
362: pay_assignment_actions ppac,
363: pay_action_interlocks ppai
364: WHERE mpa.payroll_action_id =c_payroll_action_id
365: AND p.person_id = a.person_id
366: AND p.person_id BETWEEN c_start_person_id AND c_end_person_id

Line 389: pay_assignment_actions paa1,

385: AND pay_au_payment_summary.get_archive_value('X_PAYMENT_SUMMARY_TYPE', apac.assignment_action_id)='A'
386: AND NOT EXISTS /* 5471093 */
387: (SELECT /*+ ORDERED */ locked_action_id
388: FROM pay_action_interlocks pail,
389: pay_assignment_actions paa1,
390: pay_payroll_actions paas
391: WHERE paas.action_type='X'
392: and paas.action_status='C'
393: AND paas.report_type='AU_PS_DATA_FILE'

Line 404: SELECT /*+ INDEX (apac PAY_ASSIGNMENT_ACTIONS_N50)

400: /* 9113084 - Cursor fetches assignments for Amended Data File when RANGE_PERSON_ID is enabled */
401: CURSOR rg_process_assignments_amend
402: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
403: c_chunk IN NUMBER) is
404: SELECT /*+ INDEX (apac PAY_ASSIGNMENT_ACTIONS_N50)
405: INDEX (ppac PAY_ASSIGNMENT_ACTIONS_PK)
406: INDEX(mpa PAY_PAYROLL_ACTIONS_PK)
407: INDEX(ppai PAY_ACTION_INTERLOCKS_FK2)
408: INDEX (p PER_PEOPLE_F_PK)

Line 405: INDEX (ppac PAY_ASSIGNMENT_ACTIONS_PK)

401: CURSOR rg_process_assignments_amend
402: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
403: c_chunk IN NUMBER) is
404: SELECT /*+ INDEX (apac PAY_ASSIGNMENT_ACTIONS_N50)
405: INDEX (ppac PAY_ASSIGNMENT_ACTIONS_PK)
406: INDEX(mpa PAY_PAYROLL_ACTIONS_PK)
407: INDEX(ppai PAY_ACTION_INTERLOCKS_FK2)
408: INDEX (p PER_PEOPLE_F_PK)
409: INDEX(a PER_ASSIGNMENTS_F_PK) */

Line 417: pay_assignment_actions apac,

413: FROM pay_payroll_actions mpa,
414: per_people_f p,
415: per_assignments_f a,
416: pay_payroll_actions apa,
417: pay_assignment_actions apac,
418: pay_payroll_actions ppa,
419: pay_assignment_actions ppac,
420: pay_action_interlocks ppai,
421: pay_population_ranges ppr

Line 419: pay_assignment_actions ppac,

415: per_assignments_f a,
416: pay_payroll_actions apa,
417: pay_assignment_actions apac,
418: pay_payroll_actions ppa,
419: pay_assignment_actions ppac,
420: pay_action_interlocks ppai,
421: pay_population_ranges ppr
422: WHERE mpa.payroll_action_id =c_payroll_action_id
423: AND ppr.payroll_action_id = mpa.payroll_action_id

Line 449: pay_assignment_actions paa1,

445: AND pay_au_payment_summary.get_archive_value('X_PAYMENT_SUMMARY_TYPE', apac.assignment_action_id)='A'
446: AND NOT EXISTS
447: (SELECT /*+ ORDERED */ locked_action_id
448: FROM pay_action_interlocks pail,
449: pay_assignment_actions paa1,
450: pay_payroll_actions paas
451: WHERE paas.action_type='X'
452: and paas.action_status='C'
453: AND paas.report_type='AU_PS_DATA_FILE'

Line 460: SELECT pay_assignment_actions_s.NEXTVAL

456: AND pail.locked_action_id = ppac.assignment_action_id);
457:
458:
459: CURSOR next_action_id IS
460: SELECT pay_assignment_actions_s.NEXTVAL
461: FROM dual;
462:
463: BEGIN
464:

Line 713: (p_payroll_action_id in pay_assignment_actions.payroll_action_id%type,

709: -- Used to actually perform the archival of data. We are not archiving
710: -- any data here, so this is null.
711: ------------------------------------------------------------------------+
712: procedure archive_code
713: (p_payroll_action_id in pay_assignment_actions.payroll_action_id%type,
714: p_effective_date in date)
715: is
716:
717: begin