DBA Data[Home] [Help]

APPS.PAY_CTY_BUS dependencies on PER_ADDRESSES

Line 1176: per_addresses pa

1172: cursor chk_city_residence(p_csr_tmp_date in date)
1173: is
1174: select 1
1175: from per_assignments_f paf,
1176: per_addresses pa
1177: where paf.assignment_id = p_assignment_id
1178: and pa.person_id = paf.person_id
1179: and pa.primary_flag = 'Y'
1180: and nvl(pa.date_to, hr_api.g_eot) > p_csr_tmp_date