APPS.ZX_CORE_REP_EXTRACT_PKG dependencies on ZX_REPORTING_TYPES_B

Line 761: FROM zx_reporting_types_b rep_type,

757: BULK COLLECT INTO l_detail_tax_line_id_tbl,
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 ,

Line 1090: FROM zx_reporting_types_b rep_type,

1086: FOR i in 1..nvl(p_detail_tax_line_id_tbl.last,0) LOOP
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

Line 1127: FROM zx_reporting_types_b rep_type,

1123: FOR i in 1..nvl(p_detail_tax_line_id_tbl.last,0) LOOP
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

Line 2037: FROM zx_reporting_types_b rep_type,

2033:
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