DBA Data[Home] [Help]

APPS.OKC_VERSION_PVT dependencies on OKC_PRICE_ATT_VALUES_H

Line 1542: delete FROM OKC_PRICE_ATT_VALUES_H

1538:
1539: -- bug 5679233
1540: -- decomposed the delete query into following two sub queries because of performance issues
1541:
1542: delete FROM OKC_PRICE_ATT_VALUES_H
1543: WHERE (chr_id= p_chr_id )
1544: and ((MAJOR_VERSION = -1
1545: and p_called_from = 'ERASE_SAVED_VERSION')
1546: or (p_called_from = 'RESTORE_VERSION'

Line 1550: delete FROM OKC_PRICE_ATT_VALUES_H

1546: or (p_called_from = 'RESTORE_VERSION'
1547: and (major_version >= l_major_version
1548: or major_version = -1)));
1549:
1550: delete FROM OKC_PRICE_ATT_VALUES_H
1551: WHERE (CLE_ID IN (SELECT ID FROM OKC_K_LINES_B WHERE DNZ_CHR_ID=p_chr_id ) )
1552: and ((MAJOR_VERSION = -1
1553: and p_called_from = 'ERASE_SAVED_VERSION')
1554: or (p_called_from = 'RESTORE_VERSION'