DBA Data[Home] [Help]

APPS.PAY_US_NACHA_IAT_TAPE dependencies on PER_ADDRESSES_V

Line 89: PER_ADDRESSES_V pav

85: pav.D_COUNTRY ,
86: pav.POSTAL_CODE
87: FROM per_all_assignments_f paa,
88: per_all_people_f pap,
89: PER_ADDRESSES_V pav
90: WHERE paa.person_id = pap.person_id
91: AND paa.assignment_id = g_assignment_id
92: and l_direct_dep_date BETWEEN paa.EFFECTIVE_START_DATE AND NVL(paa.EFFECTIVE_END_DATE,l_direct_dep_date)
93: and pav.person_id = pap.person_id

Line 120: PER_ADDRESSES_V pav

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
123: and ppp.pre_payment_id = l_prepayment_id
124: and ppp.assignment_action_id = pai.locking_action_id