DBA Data[Home] [Help]

APPS.ZX_CORE_REP_EXTRACT_PKG dependencies on ZX_REPORT_CODES_ASSOC

Line 763: zx_report_codes_assoc rep_ass,

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

Line 1092: zx_report_codes_assoc rep_ass,

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

Line 1129: zx_report_codes_assoc rep_ass,

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