APPS.ZX_TEST_API dependencies on ZX_RATES_B

Line 8372: zx_rates_b.tax_rate_code, --l_TAX_RATE_NAME ,-- Has to be calculated

8368: zx_lines.TAX_HOLD_CODE ,
8369: zx_lines.TAX_HOLD_RELEASED_CODE ,
8370: zx_lines.LINE_AMT ,
8371: zx_lines.TAX_JURISDICTION_CODE ,
8372: zx_rates_b.tax_rate_code, --l_TAX_RATE_NAME ,-- Has to be calculated
8373: zx_rates_b.rate_type_code, --l_TAX_RATE_TYPE_CODE ,-- Has to be calculated
8374: zx_lines.TAX_DETERMINE_DATE ,
8375: zx_lines.CANCEL_FLAG ,
8376: zx_lines.EVENT_CLASS_CODE ,

Line 8373: zx_rates_b.rate_type_code, --l_TAX_RATE_TYPE_CODE ,-- Has to be calculated

8369: zx_lines.TAX_HOLD_RELEASED_CODE ,
8370: zx_lines.LINE_AMT ,
8371: zx_lines.TAX_JURISDICTION_CODE ,
8372: zx_rates_b.tax_rate_code, --l_TAX_RATE_NAME ,-- Has to be calculated
8373: zx_rates_b.rate_type_code, --l_TAX_RATE_TYPE_CODE ,-- Has to be calculated
8374: zx_lines.TAX_DETERMINE_DATE ,
8375: zx_lines.CANCEL_FLAG ,
8376: zx_lines.EVENT_CLASS_CODE ,
8377: zx_lines.EVENT_TYPE_CODE ,

Line 8382: ZX_RATES_B

8378: p_service ,
8379: 'N', --ERROR_FLAG ,
8380: g_party_rec.prod_family_grp_code||' LINE' --ERROR_MESSAGE
8381: FROM ZX_LINES,
8382: ZX_RATES_B
8383: WHERE trx_id = p_transaction_id
8384: AND application_id = l_application_id
8385: AND entity_code = l_entity_code
8386: AND event_class_code = l_event_class_code

Line 8387: AND zx_lines.tax_rate_id(+) = zx_rates_b.tax_rate_id

8383: WHERE trx_id = p_transaction_id
8384: AND application_id = l_application_id
8385: AND entity_code = l_entity_code
8386: AND event_class_code = l_event_class_code
8387: AND zx_lines.tax_rate_id(+) = zx_rates_b.tax_rate_id
8388: ORDER BY trx_id,
8389: trx_line_id;
8390:
8391:

Line 8491: zx_rates_b.tax_rate_code, --null, --TAX_RATE_NAME ,

8487: null, --TAX_HOLD_CODE ,
8488: null, --TAX_HOLD_RELEASED_CODE ,
8489: null, --LINE_AMT ,
8490: zx_lines_summary.TAX_JURISDICTION_CODE ,
8491: zx_rates_b.tax_rate_code, --null, --TAX_RATE_NAME ,
8492: zx_rates_b.rate_type_code, --null, --TAX_RATE_TYPE ,
8493: null, --TAX_DETERMINE_DATE ,
8494: zx_lines_summary.CANCEL_FLAG ,
8495: zx_lines_summary.EVENT_CLASS_CODE ,

Line 8492: zx_rates_b.rate_type_code, --null, --TAX_RATE_TYPE ,

8488: null, --TAX_HOLD_RELEASED_CODE ,
8489: null, --LINE_AMT ,
8490: zx_lines_summary.TAX_JURISDICTION_CODE ,
8491: zx_rates_b.tax_rate_code, --null, --TAX_RATE_NAME ,
8492: zx_rates_b.rate_type_code, --null, --TAX_RATE_TYPE ,
8493: null, --TAX_DETERMINE_DATE ,
8494: zx_lines_summary.CANCEL_FLAG ,
8495: zx_lines_summary.EVENT_CLASS_CODE ,
8496: null, --EVENT_TYPE_CODE ,

Line 8501: ZX_RATES_B

8497: p_service ,
8498: 'N', --ERROR_FLAG ,
8499: g_party_rec.prod_family_grp_code||' SUMMARY' --ERROR_MESSAGE
8500: FROM ZX_LINES_SUMMARY,
8501: ZX_RATES_B
8502: WHERE trx_id = p_transaction_id
8503: AND application_id = l_application_id
8504: AND entity_code = l_entity_code
8505: AND event_class_code = l_event_class_code

Line 8506: AND zx_lines_summary.tax_rate_id(+) = zx_rates_b.tax_rate_id;

8502: WHERE trx_id = p_transaction_id
8503: AND application_id = l_application_id
8504: AND entity_code = l_entity_code
8505: AND event_class_code = l_event_class_code
8506: AND zx_lines_summary.tax_rate_id(+) = zx_rates_b.tax_rate_id;
8507:
8508:
8509: --------------------------------------------------
8510: -- Insert ZX_REC_NREC_DIST data

Line 8616: zx_rates_b

8612: p_service ,
8613: 'N' , --ERROR_FLAG
8614: g_party_rec.prod_family_grp_code||' DIST' --ERROR_MESSAGE
8615: FROM zx_rec_nrec_dist,
8616: zx_rates_b
8617: WHERE trx_id = p_transaction_id
8618: AND application_id = l_application_id
8619: AND entity_code = l_entity_code
8620: AND event_class_code = l_event_class_code

Line 8621: AND zx_rec_nrec_dist.tax_rate_id(+) = zx_rates_b.tax_rate_id;

8617: WHERE trx_id = p_transaction_id
8618: AND application_id = l_application_id
8619: AND entity_code = l_entity_code
8620: AND event_class_code = l_event_class_code
8621: AND zx_rec_nrec_dist.tax_rate_id(+) = zx_rates_b.tax_rate_id;
8622:
8623: ELSIF p_error_flag = 'Y' THEN
8624: Write_Message('Error messages will be inserted in the Report Table');
8625: -------------------------------------------------------------------