DBA Data[Home] [Help]

APPS.JG_ZZ_RGRH_PKG dependencies on XLE_ETB_PROFILES

Line 26: SELECT etbp.party_id INTO x_me_party_id FROM XLE_ETB_PROFILES etbp

22: P_ADDRESS3 := 'decode(substr(address_line_2,1,60),null,null,postal_code||'' ''||town_or_city||''- ''||''Italy'')';
23: P_FISCAL_CODE := 'registration_number';
24: P_FISCAL_COMPANY_NAME := 'name';
25: BEGIN
26: SELECT etbp.party_id INTO x_me_party_id FROM XLE_ETB_PROFILES etbp
27: WHERE etbp.main_establishment_flag = 'Y'
28: AND etbp.legal_entity_id = P_LEGAL_ENTITY_ID;
29: IF x_me_party_id is not null THEN
30: x_registration_number := ZX_API_PUB.get_default_tax_reg