APPS.ZX_UPGRADE_CONTROL_PKG dependencies on ZX_REPORTING_TYPES_B

Line 904: zx_reporting_types_b

900: fnd_global.user_id,
901: sysdate,
902: fnd_global.conc_login_id
903: FROM zx_party_tax_profile ptp ,
904: zx_reporting_types_b
905: WHERE ptp.party_id = p_vendor_site_id and
906: ptp.Party_Type_Code = 'SUPPLIER_SITE' and
907: reporting_type_code = 'FISCAL PRINTER');
908:

Line 940: zx_reporting_types_b

936: fnd_global.user_id,
937: sysdate,
938: fnd_global.conc_login_id
939: FROM zx_party_tax_profile ptp ,
940: zx_reporting_types_b
941: WHERE ptp.party_id = p_vendor_site_id and
942: ptp.Party_Type_Code = 'SUPPLIER_SITE' and
943: reporting_type_code = 'CAI NUMBER');
944:

Line 1208: FROM ZX_REPORTING_TYPES_B

1204: LAST_UPDATE_DATE = sysdate,
1205: LAST_UPDATE_LOGIN = fnd_global.conc_login_id
1206: WHERE ENTITY_CODE = 'ZX_PARTY_TAX_PROFILE' AND
1207: REPORTING_TYPE_ID = (SELECT REPORTING_TYPE_ID
1208: FROM ZX_REPORTING_TYPES_B
1209: WHERE REPORTING_TYPE_CODE ='FISCAL PRINTER')
1210: AND ENTITY_ID in (SELECT Party_Tax_Profile_Id
1211: FROM zx_party_tax_profile ptp
1212: WHERE ptp.party_id = p_vendor_site_id

Line 1226: FROM ZX_REPORTING_TYPES_B

1222: LAST_UPDATE_DATE = sysdate,
1223: LAST_UPDATE_LOGIN = fnd_global.conc_login_id
1224: WHERE ENTITY_CODE = 'ZX_PARTY_TAX_PROFILE' AND
1225: REPORTING_TYPE_ID = (SELECT REPORTING_TYPE_ID
1226: FROM ZX_REPORTING_TYPES_B
1227: WHERE REPORTING_TYPE_CODE ='CAI NUMBER')
1228: AND ENTITY_ID in (SELECT Party_Tax_Profile_Id
1229: FROM zx_party_tax_profile ptp
1230: WHERE ptp.party_id = p_vendor_site_id