APPS.PAY_US_NACHA_TAPE dependencies on PAY_PAYROLLS_F

Line 68: pay_payrolls_f.

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
72: query and in the where clause.

Line 177: pay_payrolls_f pay,

173: decode(nvl(to_char(opm.defined_balance_id),'Y'),'Y','Y','N')
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