APPS.XLE_REGISTRATIONS_VAL_PVT dependencies on XLE_JURISDICTIONS_B

Line 43: FROM xle_jurisdictions_b jur,

39: 'ETB', jur.registration_code_etb) registration_code,
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))

Line 61: l_legislative_cat_code xle_jurisdictions_b.legislative_cat_code%TYPE;

57: WHERE source_table = p_source_table
58: AND jurisdiction_id = p_jurisdiction_id
59: AND registration_number = p_registration_number
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';

Line 62: l_registration_code xle_jurisdictions_b.registration_code_le%TYPE;

58: AND jurisdiction_id = p_jurisdiction_id
59: AND registration_number = p_registration_number
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);

Line 63: l_required_flag xle_jurisdictions_b.required_le_flag%TYPE;

59: AND registration_number = p_registration_number
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;