DBA Data[Home] [Help]

APPS.CSI_INSTANCE_PARTIES_VLD_PVT dependencies on DUAL

Line 788: FROM sys.dual;

784:
785: BEGIN
786: SELECT CSI_I_PARTIES_S.nextval
787: INTO l_inst_party_id
788: FROM sys.dual;
789: RETURN l_inst_party_id;
790: END gen_inst_party_id;
791:
792: /*-----------------------------------------------------------*/

Line 804: FROM sys.dual;

800: l_inst_party_his_id NUMBER;
801: BEGIN
802: SELECT CSI_I_PARTIES_H_S.nextval
803: INTO l_inst_party_his_id
804: FROM sys.dual;
805: RETURN l_inst_party_his_id ;
806: END gen_inst_party_hist_id;
807:
808: /*-----------------------------------------------------------*/

Line 1358: FROM sys.dual;

1354: BEGIN
1355:
1356: SELECT CSI_IP_ACCOUNTS_S.nextval
1357: INTO l_ip_account_id
1358: FROM sys.dual;
1359: RETURN l_ip_account_id ;
1360: END gen_ip_account_id;
1361:
1362: /*-----------------------------------------------------------*/

Line 1374: FROM sys.dual;

1370: l_ip_account_hist_id NUMBER;
1371: BEGIN
1372: SELECT CSI_IP_ACCOUNTS_H_S.nextval
1373: INTO l_ip_account_hist_id
1374: FROM sys.dual;
1375: RETURN l_ip_account_hist_id ;
1376: END gen_ip_account_hist_id;
1377:
1378: /*------------------------------------------------------------*/

Line 1441: FROM sys.dual;

1437:
1438: BEGIN
1439: SELECT CSI_I_VERSION_LABELS_S.nextval
1440: INTO l_version_label_id
1441: FROM sys.dual;
1442: RETURN l_version_label_id;
1443: END gen_ver_label_id;
1444:
1445: /*-----------------------------------------------------------*/

Line 1489: FROM sys.dual;

1485:
1486: BEGIN
1487: SELECT CSI_I_VERSION_LABELS_H_S.nextval
1488: INTO l_version_label_hist_id
1489: FROM sys.dual;
1490:
1491: RETURN l_version_label_hist_id;
1492:
1493: END gen_ver_label_hist_id;

Line 1509: FROM sys.dual;

1505:
1506: BEGIN
1507: SELECT CSI_I_ASSETS_S.nextval
1508: INTO l_inst_asset_id
1509: FROM sys.dual;
1510:
1511: RETURN l_inst_asset_id;
1512:
1513: END gen_inst_asset_id;

Line 1624: FROM sys.dual;

1620:
1621: BEGIN
1622: SELECT CSI_I_ASSETS_H_S.nextval
1623: INTO l_inst_asset_hist_id
1624: FROM sys.dual;
1625: RETURN l_inst_asset_hist_id;
1626: END gen_inst_asset_hist_id;
1627:
1628: /*-----------------------------------------------------------*/