APPS.ZX_CORE_REP_EXTRACT_PKG dependencies on ZX_REPORTING_CODES_B

Line 762: zx_reporting_codes_b rep_code,

758: l_trx_id_tbl,
759: l_country_code_tbl,
760: l_internal_organization_id_tbl --Bug 5251425
761: FROM zx_reporting_types_b rep_type,
762: zx_reporting_codes_b rep_code,
763: zx_report_codes_assoc rep_ass,
764: zx_party_tax_profile ptp,
765: xle_etb_profiles xle_pf ,
766: zx_rep_trx_detail_t dtl

Line 781: FROM zx_reporting_codes_b code

777: AND dtl.request_id = p_request_id
778: AND EXISTS
779: (
780: SELECT 1
781: FROM zx_reporting_codes_b code
782: WHERE code.reporting_type_id = rep_code.reporting_type_id
783: and code.reporting_code_char_value = dtl.billing_tp_country
784: );
785:

Line 1091: zx_reporting_codes_b rep_code,

1087: BEGIN
1088: SELECT rep_code.reporting_code_char_value
1089: INTO p_org_vat_num_tbl(i)
1090: FROM zx_reporting_types_b rep_type,
1091: zx_reporting_codes_b rep_code,
1092: zx_report_codes_assoc rep_ass,
1093: zx_party_tax_profile ptp,
1094: xle_etb_profiles xle_pf
1095: -- zx_rep_trx_detail_t dtl

Line 1128: zx_reporting_codes_b rep_code,

1124: BEGIN
1125: SELECT rep_code.reporting_code_char_value
1126: INTO p_adj_tax_code_tbl(i)
1127: FROM zx_reporting_types_b rep_type,
1128: zx_reporting_codes_b rep_code,
1129: zx_report_codes_assoc rep_ass,
1130: zx_rates_b zx_rate
1131: WHERE rep_type.reporting_type_id = rep_code.reporting_type_id
1132: AND rep_type.reporting_type_code = 'ZX_ADJ_TAX_CLASSIF_CODE'

Line 2038: zx_reporting_codes_b rep_code

2034: /* BEGIN
2035: SELECT rep_code.reporting_code_char_value
2036: INTO l_country_code_reg_num_tbl(i)
2037: FROM zx_reporting_types_b rep_type,
2038: zx_reporting_codes_b rep_code
2039: WHERE rep_type.reporting_type_id = rep_code.reporting_type_id
2040: AND rep_type.reporting_type_code = 'MEMBER STATE'
2041: AND rep_code.reporting_code_char_value
2042: = (SubStr(Nvl(Nvl(l_ship_to_site_tax_reg_num_tbl(i),