APPS.ZX_JL_EXTRACT_PKG dependencies on ZX_REPORTING_TYPES_B

Line 8991: FROM zx_reporting_types_b rep_type,

8987: IF l_dgi_trx_code_tbl(p_tax_rate_id_tbl(i)) IS NULL THEN
8988: BEGIN
8989: SELECT rep_ass.reporting_code_char_value
8990: INTO l_dgi_trx_code_tbl(p_tax_rate_id_tbl(i))
8991: FROM zx_reporting_types_b rep_type,
8992: zx_report_codes_assoc rep_ass
8993: WHERE rep_type.reporting_type_code = 'AR_DGI_TRX_CODE'
8994: AND rep_ass.reporting_type_id = rep_type.reporting_type_id
8995: AND rep_ass.entity_code = 'ZX_RATES'

Line 9103: FROM zx_reporting_types_b rep_type,

9099: IF l_tax_auth_categ_tbl(p_tax_rate_id_tbl(i)) IS NULL THEN
9100: BEGIN
9101: SELECT rep_ass.reporting_code_char_value
9102: INTO l_tax_auth_categ_tbl(p_tax_rate_id_tbl(i))
9103: FROM zx_reporting_types_b rep_type,
9104: zx_report_codes_assoc rep_ass
9105: WHERE rep_type.reporting_type_code = 'AR_TAX_AUTHORITY_CATEG'
9106: AND rep_ass.reporting_type_id = rep_type.reporting_type_id
9107: AND rep_ass.entity_code = 'ZX_RATES'

Line 9216: FROM zx_reporting_types_b rep_type,

9212: IF l_prov_juris_code_tbl(p_tax_rate_id_tbl(i)) IS NULL THEN
9213: BEGIN
9214: /* SELECT rep_ass.reporting_code_char_value
9215: INTO l_prov_juris_code_tbl(p_tax_rate_id_tbl(i))
9216: FROM zx_reporting_types_b rep_type,
9217: zx_report_codes_assoc rep_ass
9218: WHERE rep_type.reporting_type_code = 'AR_TURN_OVER_JUR_CODE'
9219: AND rep_ass.reporting_type_id = rep_type.reporting_type_id
9220: AND rep_ass.entity_code = 'ZX_RATES'

Line 9316: FROM zx_reporting_types_b rep_type,

9312: IF l_mun_juris_code_tbl(p_tax_rate_id_tbl(i)) IS NULL THEN
9313: BEGIN
9314: /* SELECT rep_ass.reporting_code_char_value
9315: INTO l_mun_juris_code_tbl(p_tax_rate_id_tbl(i))
9316: FROM zx_reporting_types_b rep_type,
9317: zx_report_codes_assoc rep_ass
9318: WHERE rep_type.reporting_type_code = 'AR_MUNICIPAL_JUR'
9319: AND rep_ass.reporting_type_id = rep_type.reporting_type_id
9320: AND rep_ass.entity_code = 'ZX_RATES'

Line 9495: FROM zx_reporting_types_b rep_type,

9491: 'P_TAX_REGIME_CODE_TBL : '||P_TAX_REGIME_CODE_TBL(i));
9492: END IF;
9493: SELECT rep_ass.reporting_code_char_value
9494: INTO l_cai_num_tbl(p_trx_id_tbl(i))
9495: FROM zx_reporting_types_b rep_type,
9496: zx_report_codes_assoc rep_ass
9497: WHERE rep_type.reporting_type_code = 'CAI NUMBER'
9498: AND rep_ass.reporting_type_id = rep_type.reporting_type_id
9499: AND rep_ass.entity_code = 'ZX_PARTY_TAX_PROFILE'

Line 9691: FROM zx_reporting_types_b rep_type,

9687: IF l_fiscal_printer_tbl(p_trx_id_tbl(i)) is null THEN
9688: BEGIN
9689: SELECT rep_ass.reporting_code_char_value
9690: INTO l_rep_fiscal_printer_tbl(i)
9691: FROM zx_reporting_types_b rep_type,
9692: zx_report_codes_assoc rep_ass
9693: WHERE rep_type.reporting_type_code = 'FISCAL PRINTER'
9694: AND rep_ass.reporting_type_id = rep_type.reporting_type_id
9695: AND rep_ass.entity_code = 'ZX_PARTY_TAX_PROFILE'