DBA Data[Home] [Help]

APPS.ARP_PROCESS_RETURNS dependencies on DUAL

Line 1500: FROM dual

1496: IF x_rec_proc_option = 'REFUND' THEN
1497: BEGIN
1498: SELECT 'Y', arp_standard.fnd_message('AR_RID_NOT_REMITTED_OR_CLEARED')
1499: INTO x_rec_in_doubt, x_rid_reason
1500: FROM dual
1501: WHERE
1502: (
1503: NOT EXISTS
1504: (

Line 1533: FROM dual

1529: ---
1530: BEGIN
1531: SELECT 'Y', arp_standard.fnd_message('AR_RID_NOT_CLEARED')
1532: INTO x_rec_in_doubt, x_rid_reason
1533: FROM dual
1534: WHERE
1535: (
1536: NOT EXISTS
1537: (

Line 1568: FROM dual

1564: ---
1565: BEGIN
1566: SELECT 'Y', arp_standard.fnd_message('AR_RID_CLAIM_OR_CB_APP_EXISTS')
1567: INTO x_rec_in_doubt, x_rid_reason
1568: FROM dual
1569: WHERE
1570: EXISTS
1571: (
1572: SELECT 1

Line 1599: FROM dual

1595: ---
1596: BEGIN
1597: SELECT 'Y', arp_standard.fnd_message('AR_RID_RECEIPT_REVERSED')
1598: INTO x_rec_in_doubt, x_rid_reason
1599: FROM dual
1600: WHERE
1601: EXISTS
1602: (
1603: SELECT 1