DBA Data[Home] [Help]

APPS.JG_ZZ_AUDIT_GL_PKG dependencies on HZ_LOCATIONS

Line 50: l_country hz_locations.country%TYPE;

46:
47: l_taxpayer_id jg_zz_vat_trx_details.taxpayer_id%TYPE;
48: l_company_name xle_registrations.registered_name%TYPE;
49: l_registration_number xle_registrations.registration_number%TYPE;
50: l_country hz_locations.country%TYPE;
51: l_address1 hz_locations.address1%TYPE;
52: l_address2 hz_locations.address2%TYPE;
53: l_address3 hz_locations.address3%TYPE;
54: l_address4 hz_locations.address4%TYPE;

Line 51: l_address1 hz_locations.address1%TYPE;

47: l_taxpayer_id jg_zz_vat_trx_details.taxpayer_id%TYPE;
48: l_company_name xle_registrations.registered_name%TYPE;
49: l_registration_number xle_registrations.registration_number%TYPE;
50: l_country hz_locations.country%TYPE;
51: l_address1 hz_locations.address1%TYPE;
52: l_address2 hz_locations.address2%TYPE;
53: l_address3 hz_locations.address3%TYPE;
54: l_address4 hz_locations.address4%TYPE;
55: l_city hz_locations.city%TYPE;

Line 52: l_address2 hz_locations.address2%TYPE;

48: l_company_name xle_registrations.registered_name%TYPE;
49: l_registration_number xle_registrations.registration_number%TYPE;
50: l_country hz_locations.country%TYPE;
51: l_address1 hz_locations.address1%TYPE;
52: l_address2 hz_locations.address2%TYPE;
53: l_address3 hz_locations.address3%TYPE;
54: l_address4 hz_locations.address4%TYPE;
55: l_city hz_locations.city%TYPE;
56: l_postal_code hz_locations.postal_code%TYPE;

Line 53: l_address3 hz_locations.address3%TYPE;

49: l_registration_number xle_registrations.registration_number%TYPE;
50: l_country hz_locations.country%TYPE;
51: l_address1 hz_locations.address1%TYPE;
52: l_address2 hz_locations.address2%TYPE;
53: l_address3 hz_locations.address3%TYPE;
54: l_address4 hz_locations.address4%TYPE;
55: l_city hz_locations.city%TYPE;
56: l_postal_code hz_locations.postal_code%TYPE;
57: l_contact hz_parties.party_name%TYPE;

Line 54: l_address4 hz_locations.address4%TYPE;

50: l_country hz_locations.country%TYPE;
51: l_address1 hz_locations.address1%TYPE;
52: l_address2 hz_locations.address2%TYPE;
53: l_address3 hz_locations.address3%TYPE;
54: l_address4 hz_locations.address4%TYPE;
55: l_city hz_locations.city%TYPE;
56: l_postal_code hz_locations.postal_code%TYPE;
57: l_contact hz_parties.party_name%TYPE;
58: l_phone_number hz_contact_points.phone_number%TYPE;

Line 55: l_city hz_locations.city%TYPE;

51: l_address1 hz_locations.address1%TYPE;
52: l_address2 hz_locations.address2%TYPE;
53: l_address3 hz_locations.address3%TYPE;
54: l_address4 hz_locations.address4%TYPE;
55: l_city hz_locations.city%TYPE;
56: l_postal_code hz_locations.postal_code%TYPE;
57: l_contact hz_parties.party_name%TYPE;
58: l_phone_number hz_contact_points.phone_number%TYPE;
59: l_period_year NUMBER;

Line 56: l_postal_code hz_locations.postal_code%TYPE;

52: l_address2 hz_locations.address2%TYPE;
53: l_address3 hz_locations.address3%TYPE;
54: l_address4 hz_locations.address4%TYPE;
55: l_city hz_locations.city%TYPE;
56: l_postal_code hz_locations.postal_code%TYPE;
57: l_contact hz_parties.party_name%TYPE;
58: l_phone_number hz_contact_points.phone_number%TYPE;
59: l_period_year NUMBER;
60: