DBA Data[Home] [Help]

APPS.JE_IT_XML_LISTING_PKG dependencies on ZX_REGISTRATIONS

Line 34: FROM zx_registrations reg,

30: FUNCTION validate_vat_reg_num (p_vat_reg_num VARCHAR2, p_party_type_code VARCHAR2) RETURN VARCHAR2
31: IS
32: CURSOR tax_reg_num_csr(c_registration_number varchar2, c_party_type_code varchar2) IS
33: SELECT ptp.party_id
34: FROM zx_registrations reg,
35: zx_party_tax_profile ptp
36: WHERE ptp.party_tax_profile_id = reg.party_tax_profile_id
37: AND reg.registration_number = c_registration_number
38: AND sysdate >= reg.effective_from