APPS.ZX_JL_EXTRACT_PKG dependencies on ZX_REPORT_CODES_ASSOC

Line 8992: zx_report_codes_assoc rep_ass

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'
8996: AND rep_ass.entity_id =P_TAX_RATE_ID_TBL(i)

Line 9104: zx_report_codes_assoc rep_ass

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'
9108: AND rep_ass.entity_id =P_TAX_RATE_ID_TBL(i)

Line 9217: zx_report_codes_assoc rep_ass

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'
9221: AND rep_ass.entity_id =P_TAX_RATE_ID_TBL(i)

Line 9317: zx_report_codes_assoc rep_ass

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'
9321: AND rep_ass.entity_id =P_TAX_RATE_ID_TBL(i)

Line 9496: zx_report_codes_assoc rep_ass

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'
9500: AND rep_ass.entity_id = P_BILL_FROM_SITE_PROF_ID_TBL(i)

Line 9692: zx_report_codes_assoc rep_ass

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'
9696: AND rep_ass.entity_id = P_BILL_FROM_SITE_PROF_ID_TBL(i)