DBA Data[Home] [Help]

APPS.PAY_US_NACHA_IAT_TAPE dependencies on PER_ALL_PEOPLE_F

Line 88: per_all_people_f pap,

84: pav.REGION_1 ,
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)

Line 115: per_all_people_f pap,

111: pav.REGION_1 ,
112: pav.D_COUNTRY ,
113: pav.POSTAL_CODE
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,