APPS.ZX_PARTY_MERGE_PKG dependencies on FND_LOOKUPS

Line 1863: FROM fnd_lookups

1859: ) IS
1860:
1861: CURSOR c_party_type (c_party_type zx_party_tax_profile.party_type_code%TYPE) IS
1862: SELECT lookup_code
1863: FROM fnd_lookups
1864: WHERE lookup_type = 'ZX_PTP_PARTY_TYPE'
1865: AND lookup_code = c_party_type
1866: AND enabled_flag = 'Y'
1867: AND SYSDATE BETWEEN start_date_active AND NVL(end_date_active,SYSDATE);