DBA Data[Home] [Help]

APPS.ZX_CORE_REP_EXTRACT_PKG dependencies on ZX_REPORT_CODES_ASSOC

Line 333: zx_report_codes_assoc rep_ass,

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 ,
336: zx_rep_trx_detail_t dtl
337: WHERE rep_type.reporting_type_id = rep_code.reporting_type_id

Line 584: zx_report_codes_assoc rep_ass,

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
587: -- zx_rep_trx_detail_t dtl
588: WHERE rep_type.reporting_type_id = rep_code.reporting_type_id

Line 621: zx_report_codes_assoc rep_ass,

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
624: AND rep_type.reporting_type_code = 'ZX_ADJ_TAX_CLASSIF_CODE'
625: AND rep_code.reporting_code_id = rep_ass.reporting_code_id