APPS.PO_DOCUMENT_TOTALS_PVT dependencies on DUAL

Line 3392: SELECT PO_DOCUMENT_TOTALS_GT_S.nextval INTO l_temp_table_key from dual;

3388:
3389: d_position := 5;
3390:
3391: -- Select the unique key to identify GTT rows for this trxn
3392: SELECT PO_DOCUMENT_TOTALS_GT_S.nextval INTO l_temp_table_key from dual;
3393:
3394: IF p_data_source = g_data_source_TRANSACTION THEN
3395:
3396: d_position := 10;

Line 3969: -- the max received, billed etc against the individual Milestone pay items

3965:
3966: d_position := 40;
3967:
3968: -- SQL WHAT: For Complex Work Qty-based lines, the total is based on
3969: -- the max received, billed etc against the individual Milestone pay items
3970: -- SQL WHERE: All qty-based GTT rows for this trxn
3971: SELECT
3972: MAX(GTTSUM.qty_total_actuals),
3973: MAX(GTTSUM.qty_total_financing),