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 1303: FROM DUAL

1299:
1300: CURSOR check_acct_csr
1301: IS
1302: SELECT 'x'
1303: FROM DUAL
1304: WHERE p_acct_id IN (
1305: SELECT ca1.cust_account_id id1
1306: FROM hz_cust_accounts ca1,
1307: hz_parties party

Line 5528: FROM DUAL;

5524: IS
5525: CURSOR l_seq_csr
5526: IS
5527: SELECT okc_k_headers_b_s.NEXTVAL
5528: FROM DUAL;
5529: BEGIN
5530:
5531: IF trunc(p_end_date) < trunc(SYSDATE)
5532: THEN

Line 7975: from dual

7971: subline_id (i),
7972: subline_sdate (i),
7973: subline_edate (i),
7974: custprod_id (i)
7975: from dual
7976: Where TRUNC (nvl(sr_date (i),idc_date (i))) >= TRUNC (idc_date (i))
7977: OR TRUNC (nvl(sr_date (i),new_edt (i))) <= TRUNC (new_edt (i))
7978: );
7979: