DBA Data[Home] [Help]

APPS.PAY_US_NACHA_TAPE dependencies on PAY_PAYROLL_ACTIONS

Line 67: between pay_payroll_actions and

63: 05-DEC-2000 ahanda 115.5 Added the RULE Hint to the cursor
64: csr_assignments. Also changed cursor
65: to use exists clause.
66: 09-JUL-2001 MESHAH 115.6 Direct join in csr_org_flex_info
67: between pay_payroll_actions and
68: pay_payrolls_f.
69: 19-JUL-2001 MESHAH 115.7 1357404 changed cursor csr_assignments to
70: include rowid as a parameter for the
71: cursor, as a select value in the

Line 178: pay_payroll_actions ppa

174: from pay_org_payment_methods_f opm,
175: pay_payment_types pt,
176: pay_org_pay_method_usages_f opmu,
177: pay_payrolls_f pay,
178: pay_payroll_actions ppa
179: where ppa.PAYROLL_ACTION_ID = p_payroll_action_id
180: and ppa.payroll_id = pay.payroll_id
181: and ppa.CONSOLIDATION_SET_ID = pay.CONSOLIDATION_SET_ID
182: and pay.PAYROLL_ID = opmu.PAYROLL_ID