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_IE_PYMT_SUMMARY_RPT_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 152: FROM pay_payroll_actions ppa,

148: SUBSTR (pea.segment4, 1, 8) account_number,
149: SUBSTR (pea.segment5, 1, 18) account_name,
150: SUM (TO_NUMBER (ppp.VALUE)) amount,
151: COUNT (ppp.VALUE) total_assignments_paid
152: FROM pay_payroll_actions ppa,
153: pay_assignment_actions paa,
154: pay_pre_payments ppp,
155: pay_org_payment_methods_f_tl popmftl,
156: pay_org_payment_methods_f popmf,

Line 191: pay_payroll_actions ppa_run

187: AND popmf.external_account_id = pea.external_account_id
188: AND exists ( SELECT NULL -- Bug 5070091 Offset payroll Change
189: FROM pay_assignment_actions paa_run,
190: pay_action_interlocks pai_run,
191: pay_payroll_actions ppa_run
192: WHERE ppa_run.payroll_id = p_payroll_id
193: AND ptp.time_period_id = p_period_id
194: AND ppa_run.date_earned between ptp.start_date and ptp.end_date
195: AND ppa_run.action_type in ('R','Q')

Line 224: FROM pay_payroll_actions ppa,

220: payroll period ***'
221: text_not_all_payroll_runs_paid
222: FROM DUAL
223: WHERE EXISTS ( SELECT NULL
224: FROM pay_payroll_actions ppa,
225: pay_assignment_actions paa,
226: per_time_periods ptp -- Bug 5070091 Offset payroll change
227: WHERE paa.payroll_action_id = ppa.payroll_action_id
228: AND ppa.action_status = 'C'

Line 238: pay_payroll_actions ppa1

234: AND NOT EXISTS (
235: SELECT 1
236: FROM pay_action_interlocks pai,
237: pay_assignment_actions paa1,
238: pay_payroll_actions ppa1
239: WHERE pai.locked_action_id = paa.assignment_action_id
240: AND pai.locking_action_id = paa1.assignment_action_id
241: AND paa1.payroll_action_id = ppa1.payroll_action_id
242: AND ppa1.action_type IN ('U', 'P')

Line 254: pay_payroll_actions ppa,

250: SELECT '*** Warning: These Amount totals include payments from previous
251: payroll period(s) ***'
252: payments_from_previous_periods
253: FROM /* per_time_periods ptp, */
254: pay_payroll_actions ppa,
255: pay_assignment_actions paa,
256: pay_pre_payments ppp
257: WHERE paa.payroll_action_id = ppa.payroll_action_id
258: AND ( p_consolidation_set_id IS NULL

Line 271: pay_payroll_actions ppa1,

267: AND EXISTS (
268: SELECT 1
269: FROM pay_action_interlocks pai,
270: pay_assignment_actions paa1,
271: pay_payroll_actions ppa1,
272: per_time_periods ptp1
273: WHERE pai.locking_action_id = paa.assignment_action_id
274: AND pai.locked_action_id = paa1.assignment_action_id
275: AND ppa1.payroll_action_id = paa1.payroll_action_id

Line 286: pay_payroll_actions ppa2,

282: AND EXISTS (
283: SELECT 1
284: FROM pay_action_interlocks pai2,
285: pay_assignment_actions paa2,
286: pay_payroll_actions ppa2,
287: per_time_periods ptp2
288: WHERE pai2.locking_action_id = paa.assignment_action_id
289: AND pai2.locked_action_id = paa2.assignment_action_id
290: AND ppa2.payroll_action_id = paa2.payroll_action_id