DBA Data[Home] [Help]

APPS.PAY_US_NACHA_TAPE dependencies on PAY_PAYROLL_ACTIONS

Line 246: pay_payroll_actions ppa,

242: from pay_element_entry_values_f peev,
243: pay_input_values_f piv_att,
244: pay_element_entries_f peef,
245: pay_run_results prr,
246: pay_payroll_actions ppa,
247: pay_assignment_actions paa,
248: pay_action_interlocks pai,
249: pay_pre_payments ppp
250: WHERE ppp.value = p_amount

Line 962: from pay_payroll_actions ppa,

958: g_direct_dep_date,
959: g_org_payment_method_id,
960: g_legislative_parameters,
961: g_csr_org_pay_third_party
962: from pay_payroll_actions ppa,
963: pay_org_payment_methods_f opm
964: where ppa.payroll_action_id = g_payroll_action_id
965: and opm.ORG_PAYMENT_METHOD_ID = ppa.org_payment_method_id
966: and ppa.effective_date between opm.EFFECTIVE_START_DATE