APPS.OKS_MASS_UPDATE_PVT dependencies on DUAL

Line 39: --| DUAL | X | | | | | |

35: --| HZ_PARTIES | X | | | | | |
36: --+---------------------------------+---+---+---+---+---+----------------------+
37: --| HZ_CUST_ACCT_RELATE_ALL | X | | | | | |
38: --+---------------------------------+---+---+---+---+---+----------------------+
39: --| DUAL | X | | | | | |
40: --+---------------------------------+---+---+---+---+---+----------------------+
41: --| OKC_K_GROUPS_B | X | | | | | |
42: --+---------------------------------+---+---+---+---+---+----------------------+
43: --| HZ_RELATIONSHIPS | X | | | | | |

Line 1307: FROM DUAL

1303:
1304: CURSOR check_acct_csr
1305: IS
1306: SELECT 'x'
1307: FROM DUAL
1308: WHERE p_acct_id IN (
1309: SELECT ca1.cust_account_id id1
1310: FROM hz_cust_accounts ca1,
1311: hz_parties party

Line 5545: FROM DUAL;

5541: IS
5542: CURSOR l_seq_csr
5543: IS
5544: SELECT okc_k_headers_b_s.NEXTVAL
5545: FROM DUAL;
5546: BEGIN
5547:
5548: IF trunc(p_end_date) < trunc(SYSDATE)
5549: THEN

Line 7992: from dual

7988: subline_id (i),
7989: subline_sdate (i),
7990: subline_edate (i),
7991: custprod_id (i)
7992: from dual
7993: Where TRUNC (nvl(sr_date (i),idc_date (i))) >= TRUNC (idc_date (i))
7994: OR TRUNC (nvl(sr_date (i),new_edt (i))) <= TRUNC (new_edt (i))
7995: );
7996: