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 173: pay_payroll_actions ppa

169: from pay_org_payment_methods_f opm,
170: pay_payment_types pt,
171: pay_org_pay_method_usages_f opmu,
172: pay_payrolls_f pay,
173: pay_payroll_actions ppa
174: where ppa.PAYROLL_ACTION_ID = p_payroll_action_id
175: and ppa.payroll_id = pay.payroll_id
176: and ppa.CONSOLIDATION_SET_ID = pay.CONSOLIDATION_SET_ID
177: and pay.PAYROLL_ID = opmu.PAYROLL_ID