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_PAYROLL_ACTIONS

Line 14: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

10: -- the archive.
11: -----------------------------------------------------------------------------+
12:
13: procedure range_code
14: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
15: p_sql out NOCOPY varchar2);
16:
17: procedure assignment_action_code
18: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

Line 18: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

14: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
15: p_sql out NOCOPY varchar2);
16:
17: procedure assignment_action_code
18: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
19: p_start_person_id in per_all_people_f.person_id%type,
20: p_end_person_id in per_all_people_f.person_id%type,
21: p_chunk in number);
22:

Line 24: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type);

20: p_end_person_id in per_all_people_f.person_id%type,
21: p_chunk in number);
22:
23: procedure initialization_code
24: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type);
25:
26: procedure archive_code
27: (p_payroll_action_id in pay_assignment_actions.payroll_action_id%type,
28: p_effective_date in date);

Line 44: pay_payroll_actions ppa

40: ppac.assignment_action_id ps_report_id,
41: 'TEST_FLAG=P',
42: 'Y'
43: from pay_assignment_actions ppac,
44: pay_payroll_actions ppa
45: where ppa.payroll_action_id =pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
46: and ppac.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_PAYROLL_ACTION',ppa.legislative_parameters)
47: AND pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG', ppac.assignment_action_id)='YES'
48: AND pay_au_payment_summary.get_archive_value('X_CURR_TERM_0_BAL_FLAG',ppac.assignment_action_id)='NO' /* Added for bug 5257622 */

Line 64: pay_payroll_actions ppa,

60: 'TEST_FLAG=P',
61: 'N'
62: from pay_assignment_actions apac,
63: pay_assignment_actions ppac,
64: pay_payroll_actions ppa,
65: pay_assignment_actions mpac,
66: pay_action_interlocks ppai,
67: pay_action_interlocks mpai
68: where apac.assignment_action_id = ppai.locked_action_id

Line 100: pay_payroll_actions ppa,

96: -- ,'ETP_PAYER_TYPE=P',
97: -- ,decode(fue.user_entity_name,'X_LUMP_SUM_C_DEDUCTIONS_ASG_YTD',decode(value ,0,null ,null,null, 'P')) etp_payer_type
98: from
99: pay_assignment_actions ppac,
100: pay_payroll_actions ppa,
101: ff_archive_items ff,
102: ff_user_entities fue
103: where ppa.payroll_action_id =pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
104: and ppac.action_status='C'

Line 136: pay_payroll_actions ppa, --self printed

132: pay_action_interlocks mpai,
133: pay_assignment_actions ppac, --self printed
134: pay_action_interlocks ppai,
135: pay_assignment_actions apac, --archive
136: pay_payroll_actions ppa, --self printed
137: ff_archive_items ff,
138: ff_user_entities fue
139: where mpac.payroll_action_id =pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
140: and mpac.action_status ='C'

Line 165: pay_payroll_actions mpa,

161: cursor payment_summary_data_val is -- (Bug 3132178) Created to be called for spawned process
162: select 'ASSIGNMENT_ACTION_ID=C',
163: ppac.assignment_action_id ps_report_id
164: from pay_assignment_actions ppac,
165: pay_payroll_actions mpa,
166: pay_assignment_actions mpac
167: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
168: AND mpac.payroll_action_id = mpa.payroll_action_id /* Added for bug 6630375 */
169: AND mpac.assignment_id = ppac.assignment_id /* Added for bug 6630375 */

Line 201: pay_payroll_actions ppa

197: pay_action_interlocks mpai,
198: pay_assignment_actions ppac,
199: pay_action_interlocks ppai,
200: pay_assignment_actions apac,
201: pay_payroll_actions ppa
202: where ppa.payroll_action_id = ppac.payroll_Action_id
203: and apac.assignment_action_id = ppai.locked_action_id
204: and apac.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ID',ppa.legislative_parameters)
205: and ppai.locking_Action_id = ppac.assignment_action_id /* 5471093 */

Line 248: pay_payroll_actions mpa,

244: cursor etp_payment_summary_data_val IS -- (Bug 3132178) Created to be called for spawned process
245: select 'ASSIGNMENT_ACTION_ID=C',
246: ppac.assignment_action_id ps_report_id
247: from pay_assignment_actions ppac,
248: pay_payroll_actions mpa,
249: pay_assignment_actions mpac
250: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
251: AND mpac.payroll_action_id = mpa.payroll_action_id /* Added for bug 6630375 */
252: AND mpac.assignment_id = ppac.assignment_id /* Added for bug 6630375 */

Line 285: pay_payroll_actions ppa --Self Printed

281: pay_action_interlocks mpai,
282: pay_assignment_actions ppac, --Self Printed
283: pay_action_interlocks ppai,
284: pay_assignment_actions apac, --Archive
285: pay_payroll_actions ppa --Self Printed
286: where mpac.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
287: and mpac.action_status = 'C'
288: and ppac.action_status = 'C'
289: and mpac.assignment_Action_id = mpai.locking_action_id