DBA Data[Home] [Help]

APPS.ZX_TPI_SERVICES_PKG dependencies on ZX_SCO_STATUS_B_V

Line 2391: FROM ZX_SCO_STATUS_B_V status

2387: status.tax_status_id
2388: INTO ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax_status_code(ptnr_tax_line_index),
2389: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax_status_id(ptnr_tax_line_index)
2390: -- FROM ZX_SCO_STATUS status -- Bug#5395227
2391: FROM ZX_SCO_STATUS_B_V status
2392: WHERE status.tax_regime_code = p_tax_regime_code
2393: AND status.default_status_flag = 'Y'
2394: AND status.tax = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax(ptnr_tax_line_index)
2395: AND (ZX_SECURITY.G_EFFECTIVE_DATE between status.default_flg_effective_from AND nvl(status.default_flg_effective_to,ZX_SECURITY.G_EFFECTIVE_DATE))