DBA Data[Home] [Help]

APPS.ARP_PROCESS_RETURNS dependencies on DUAL

Line 1472: FROM dual

1468: IF x_rec_proc_option = 'REFUND' THEN
1469: BEGIN
1470: SELECT 'Y', arp_standard.fnd_message('AR_RID_NOT_REMITTED_OR_CLEARED')
1471: INTO x_rec_in_doubt, x_rid_reason
1472: FROM dual
1473: WHERE
1474: (
1475: NOT EXISTS
1476: (

Line 1505: FROM dual

1501: ---
1502: BEGIN
1503: SELECT 'Y', arp_standard.fnd_message('AR_RID_NOT_CLEARED')
1504: INTO x_rec_in_doubt, x_rid_reason
1505: FROM dual
1506: WHERE
1507: (
1508: NOT EXISTS
1509: (

Line 1540: FROM dual

1536: ---
1537: BEGIN
1538: SELECT 'Y', arp_standard.fnd_message('AR_RID_CLAIM_OR_CB_APP_EXISTS')
1539: INTO x_rec_in_doubt, x_rid_reason
1540: FROM dual
1541: WHERE
1542: EXISTS
1543: (
1544: SELECT 1

Line 1571: FROM dual

1567: ---
1568: BEGIN
1569: SELECT 'Y', arp_standard.fnd_message('AR_RID_RECEIPT_REVERSED')
1570: INTO x_rec_in_doubt, x_rid_reason
1571: FROM dual
1572: WHERE
1573: EXISTS
1574: (
1575: SELECT 1