DBA Data[Home] [Help]

APPS.CSI_INSTANCE_PARTIES_VLD_PVT dependencies on DUAL

Line 790: FROM sys.dual;

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

Line 806: FROM sys.dual;

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

Line 1362: FROM sys.dual;

1358: BEGIN
1359:
1360: SELECT CSI_IP_ACCOUNTS_S.nextval
1361: INTO l_ip_account_id
1362: FROM sys.dual;
1363: RETURN l_ip_account_id ;
1364: END gen_ip_account_id;
1365:
1366: /*-----------------------------------------------------------*/

Line 1378: FROM sys.dual;

1374: l_ip_account_hist_id NUMBER;
1375: BEGIN
1376: SELECT CSI_IP_ACCOUNTS_H_S.nextval
1377: INTO l_ip_account_hist_id
1378: FROM sys.dual;
1379: RETURN l_ip_account_hist_id ;
1380: END gen_ip_account_hist_id;
1381:
1382: /*------------------------------------------------------------*/

Line 1445: FROM sys.dual;

1441:
1442: BEGIN
1443: SELECT CSI_I_VERSION_LABELS_S.nextval
1444: INTO l_version_label_id
1445: FROM sys.dual;
1446: RETURN l_version_label_id;
1447: END gen_ver_label_id;
1448:
1449: /*-----------------------------------------------------------*/

Line 1493: FROM sys.dual;

1489:
1490: BEGIN
1491: SELECT CSI_I_VERSION_LABELS_H_S.nextval
1492: INTO l_version_label_hist_id
1493: FROM sys.dual;
1494:
1495: RETURN l_version_label_hist_id;
1496:
1497: END gen_ver_label_hist_id;

Line 1513: FROM sys.dual;

1509:
1510: BEGIN
1511: SELECT CSI_I_ASSETS_S.nextval
1512: INTO l_inst_asset_id
1513: FROM sys.dual;
1514:
1515: RETURN l_inst_asset_id;
1516:
1517: END gen_inst_asset_id;

Line 1628: FROM sys.dual;

1624:
1625: BEGIN
1626: SELECT CSI_I_ASSETS_H_S.nextval
1627: INTO l_inst_asset_hist_id
1628: FROM sys.dual;
1629: RETURN l_inst_asset_hist_id;
1630: END gen_inst_asset_hist_id;
1631:
1632: /*-----------------------------------------------------------*/