DBA Data[Home] [Help]

APPS.PAY_US_NACHA_IAT_TAPE dependencies on PAY_PAYROLL_ACTIONS

Line 100: --Bug 9413224. Fetching Date Paid from the pay_payroll_actions table corresponding

96: or (pav.primary_flag = 'Y' ))
97: and l_direct_dep_date BETWEEN pav.date_from and NVL(pav.date_to,l_direct_dep_date))
98: order by decode(pav.address_type, 'IAT',1,2);
99:
100: --Bug 9413224. Fetching Date Paid from the pay_payroll_actions table corresponding
101: -- each pre-payment run, which is then used to fetch date tracked
102: -- address details and employee number changes.
103: cursor c_emp_details (l_prepayment_id number )is
104: (SELECT full_name ,

Line 118: pay_payroll_actions ppa,

114: FROM per_all_assignments_f paaf,
115: per_all_people_f pap,
116: pay_pre_payments ppp,
117: pay_action_interlocks pai,
118: pay_payroll_actions ppa,
119: pay_assignment_actions paa,
120: PER_ADDRESSES_V pav
121: WHERE paaf.person_id = pap.person_id
122: AND paaf.assignment_id = g_assignment_id