APPS.XLE_REGISTRATIONS_VAL_PVT dependencies on HZ_GEOGRAPHIES

Line 44: hz_geographies geo

40: DECODE(p_entity_type, 'LE' , jur.required_le_flag,
41: 'ETB', jur.required_etb_flag) required_flag,
42: geo.geography_code country_code
43: FROM xle_jurisdictions_b jur,
44: hz_geographies geo
45: WHERE jur.geography_id = geo.geography_id
46: AND jur.jurisdiction_id = p_jurisdiction_id
47: AND TRUNC(SYSDATE) BETWEEN TRUNC(Nvl(jur.effective_from, SYSDATE))
48: AND TRUNC(Nvl(jur.effective_from, SYSDATE))

Line 64: l_country_code hz_geographies.geography_code%TYPE;

60: AND (effective_to is null or effective_to >= sysdate);
61: l_legislative_cat_code xle_jurisdictions_b.legislative_cat_code%TYPE;
62: l_registration_code xle_jurisdictions_b.registration_code_le%TYPE;
63: l_required_flag xle_jurisdictions_b.required_le_flag%TYPE;
64: l_country_code hz_geographies.geography_code%TYPE;
65: l_api_name VARCHAR2(50) := 'Validate_Reg_Number';
66: l_source_table VARCHAR2(30);
67: l_registration_id NUMBER;
68: BEGIN