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 27: (p_payroll_action_id in pay_assignment_actions.payroll_action_id%type,

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);
29:
30:
31: --------------------------------------------------------------------+

Line 43: from pay_assignment_actions ppac,

39: select 'ASSIGNMENT_ACTION_ID=C',
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'

Line 62: from pay_assignment_actions apac,

58: select 'ASSIGNMENT_ACTION_ID=C',
59: apac.assignment_action_id ps_report_id,
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,

Line 63: pay_assignment_actions ppac,

59: apac.assignment_action_id ps_report_id,
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

Line 65: pay_assignment_actions mpac,

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
69: and mpac.assignment_Action_id = mpai.locking_action_id

Line 99: pay_assignment_actions ppac,

95: /*Bug 6630375 - removed ETP_PAYER_TYPE */
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')

Line 131: pay_assignment_actions mpac, --magtape

127: /*Bug 6630375 - removed ETP_PAYER_TYPE */
128: -- ,'ETP_PAYER_TYPE=P',
129: -- ,decode(fue.user_entity_name,'X_LUMP_SUM_C_DEDUCTIONS_ASG_YTD',decode(value ,0,null ,null,null, 'P')) etp_payer_type
130: from
131: pay_assignment_actions mpac, --magtape
132: pay_action_interlocks mpai,
133: pay_assignment_actions ppac, --self printed
134: pay_action_interlocks ppai,
135: pay_assignment_actions apac, --archive

Line 133: pay_assignment_actions ppac, --self printed

129: -- ,decode(fue.user_entity_name,'X_LUMP_SUM_C_DEDUCTIONS_ASG_YTD',decode(value ,0,null ,null,null, 'P')) etp_payer_type
130: from
131: pay_assignment_actions mpac, --magtape
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,

Line 135: pay_assignment_actions apac, --archive

131: pay_assignment_actions mpac, --magtape
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')

Line 164: from pay_assignment_actions ppac,

160:
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 */

Line 166: pay_assignment_actions mpac

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 */
170: AND ppac.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_PAYROLL_ACTION',mpa.legislative_parameters)

Line 197: from pay_assignment_actions mpac,

193:
194: cursor payment_summary_data is /* 5471093 */
195: select /*+ ORDERED */ 'ASSIGNMENT_ACTION_ID=C',
196: apac.assignment_action_id ps_report_id
197: from pay_assignment_actions mpac,
198: pay_action_interlocks mpai,
199: pay_assignment_actions ppac,
200: pay_action_interlocks ppai,
201: pay_assignment_actions apac,

Line 199: pay_assignment_actions ppac,

195: select /*+ ORDERED */ 'ASSIGNMENT_ACTION_ID=C',
196: apac.assignment_action_id ps_report_id
197: from pay_assignment_actions mpac,
198: pay_action_interlocks mpai,
199: pay_assignment_actions ppac,
200: pay_action_interlocks ppai,
201: pay_assignment_actions apac,
202: pay_payroll_actions ppa
203: where ppa.payroll_action_id = ppac.payroll_Action_id

Line 201: pay_assignment_actions apac,

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

Line 249: from pay_assignment_actions ppac,

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

Line 251: pay_assignment_actions mpac

247: select 'ASSIGNMENT_ACTION_ID=C',
248: ppac.assignment_action_id ps_report_id
249: from pay_assignment_actions ppac,
250: pay_payroll_actions mpa,
251: pay_assignment_actions mpac
252: where mpa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
253: AND mpac.payroll_action_id = mpa.payroll_action_id /* Added for bug 6630375 */
254: AND mpac.assignment_id = ppac.assignment_id /* Added for bug 6630375 */
255: AND ppac.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_PAYROLL_ACTION',mpa.legislative_parameters)

Line 282: pay_assignment_actions mpac, -- Magtape

278: cursor etp_payment_summary_data is
279: select /*+ORDERED*/ 'ASSIGNMENT_ACTION_ID=C',
280: apac.assignment_action_id ps_report_id
281: from
282: pay_assignment_actions mpac, -- Magtape
283: pay_action_interlocks mpai,
284: pay_assignment_actions ppac, --Self Printed
285: pay_action_interlocks ppai,
286: pay_assignment_actions apac, --Archive

Line 284: pay_assignment_actions ppac, --Self Printed

280: apac.assignment_action_id ps_report_id
281: from
282: pay_assignment_actions mpac, -- Magtape
283: pay_action_interlocks mpai,
284: pay_assignment_actions ppac, --Self Printed
285: pay_action_interlocks ppai,
286: pay_assignment_actions apac, --Archive
287: pay_payroll_actions ppa --Self Printed
288: where mpac.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 286: pay_assignment_actions apac, --Archive

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