DBA Data[Home] [Help]

APPS.ZX_TPI_SERVICES_PKG dependencies on ZX_SCO_STATUS_B_V

Line 2598: FROM ZX_SCO_STATUS_B_V status

2594: status.tax_status_id
2595: INTO ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax_status_code(ptnr_tax_line_index),
2596: ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax_status_id(ptnr_tax_line_index)
2597: -- FROM ZX_SCO_STATUS status -- Bug#5395227
2598: FROM ZX_SCO_STATUS_B_V status
2599: WHERE status.tax_regime_code = p_tax_regime_code
2600: AND status.default_status_flag = 'Y'
2601: AND status.tax = ZX_PTNR_SRVC_INTGRTN_PKG.g_tax_lines_result_tbl.tax(ptnr_tax_line_index)
2602: AND (ZX_SECURITY.G_EFFECTIVE_DATE between status.default_flg_effective_from AND nvl(status.default_flg_effective_to,ZX_SECURITY.G_EFFECTIVE_DATE))