DBA Data[Home] [Help]

APPS.PO_APPROVALLIST_S1 dependencies on DUAL

Line 1118: FROM sys.dual;

1114: l_progress := '012';
1115:
1116: SELECT po_approval_list_headers_s.nextval
1117: INTO l_new_approval_list_header_id
1118: FROM sys.dual;
1119:
1120: l_progress := '013';
1121:
1122: INSERT INTO po_approval_list_headers (

Line 1264: FROM sys.dual;

1260: SYSDATE,
1261: fnd_global.login_id,
1262: fnd_global.user_id,
1263: SYSDATE
1264: FROM sys.dual;
1265: END IF;
1266: l_index := p_approval_list.NEXT(l_index);
1267: END LOOP;
1268: END IF;

Line 1562: FROM dual;

1558: SYSDATE,
1559: fnd_global.login_id,
1560: fnd_global.user_id,
1561: SYSDATE
1562: FROM dual;
1563:
1564:
1565: get_latest_approval_list
1566: (p_document_id=>p_document_id,

Line 1982: FROM sys.dual;

1978: l_progress := '017';
1979:
1980: SELECT po_approval_list_headers_s.nextval
1981: INTO l_new_approval_list_header_id
1982: FROM sys.dual;
1983:
1984: l_progress := '018';
1985:
1986: INSERT INTO po_approval_list_headers (

Line 2139: FROM sys.dual;

2135: SYSDATE,
2136: fnd_global.login_id,
2137: fnd_global.user_id,
2138: SYSDATE
2139: FROM sys.dual;
2140: l_index1 := l_complete_approval_list.NEXT(l_index1);
2141: END IF;
2142: END LOOP;
2143: END IF;