DBA Data[Home] [Help]

APPS.ZX_CORE_REP_EXTRACT_PKG dependencies on ZX_REPORTING_TYPES_B

Line 331: FROM zx_reporting_types_b rep_type,

327: BULK COLLECT INTO l_detail_tax_line_id_tbl,
328: l_trx_id_tbl,
329: l_country_code_tbl,
330: l_internal_organization_id_tbl --Bug 5251425
331: FROM zx_reporting_types_b rep_type,
332: zx_reporting_codes_b rep_code,
333: zx_report_codes_assoc rep_ass,
334: zx_party_tax_profile ptp,
335: xle_etb_profiles xle_pf ,

Line 582: FROM zx_reporting_types_b rep_type,

578: FOR i in 1..nvl(p_detail_tax_line_id_tbl.last,0) LOOP
579: BEGIN
580: SELECT rep_code.reporting_code_char_value
581: INTO p_org_vat_num_tbl(i)
582: FROM zx_reporting_types_b rep_type,
583: zx_reporting_codes_b rep_code,
584: zx_report_codes_assoc rep_ass,
585: zx_party_tax_profile ptp,
586: xle_etb_profiles xle_pf

Line 619: FROM zx_reporting_types_b rep_type,

615: FOR i in 1..nvl(p_detail_tax_line_id_tbl.last,0) LOOP
616: BEGIN
617: SELECT rep_code.reporting_code_char_value
618: INTO p_adj_tax_code_tbl(i)
619: FROM zx_reporting_types_b rep_type,
620: zx_reporting_codes_b rep_code,
621: zx_report_codes_assoc rep_ass,
622: zx_rates_b zx_rate
623: WHERE rep_type.reporting_type_id = rep_code.reporting_type_id