DBA Data[Home] [Help]

APPS.PAY_US_EMP_TAX_RULES_PKG dependencies on PER_ADDRESSES

Line 906: PER_ADDRESSES pa,

902: pa.town_or_city,
903: pa.region_1,
904: pa.postal_code
905: from PER_ASSIGNMENTS_F paf,
906: PER_ADDRESSES pa,
907: PAY_STATE_RULES psr
908: where paf.assignment_id = P_assignment_id
909: and P_session_date between paf.effective_start_date and
910: paf.effective_end_date

Line 2341: per_addresses pa

2337: CURSOR csr_person_info(per_id NUMBER) IS
2338: SELECT paf.assignment_id
2339: FROM per_assignments_f paf,
2340: per_people_f ppf,
2341: per_addresses pa
2342: WHERE paf.person_id = ppf.person_id
2343: AND paf.assignment_type = 'E'
2344: AND ppf.person_id = pa.person_id
2345: AND pa.primary_flag = 'Y'