APPS.ARPT_SQL_FUNC_UTIL dependencies on DUAL

Line 300: From dual

296: /* Check whether Revenue Recognition is run . */
297:
298: Select decode(max(DUMMY), null , 'N','Y')
299: Into l_rule_flag
300: From dual
301: Where Exists ( Select 'Revenue recognition has been run'
302: From ra_cust_trx_line_gl_dist d
303: Where d.customer_trx_id = p_customer_trx_id
304: and d.account_class = 'REC'

Line 365: From dual

361:
362:
363: Select decode(max(DUMMY), null , 'N','Y')
364: Into l_rule_flag
365: From dual
366: Where Exists ( Select 'Revenue recognition has been run'
367: From ra_cust_trx_line_gl_dist d
368: Where d.customer_trx_id = p_customer_trx_id
369: and d.account_class <> 'REC'

Line 440: FROM DUAL

436: SELECT DECODE( MAX(DUMMY),
437: NULL, 'N',
438: 'Y')
439: INTO l_temp_flag
440: FROM DUAL
441: WHERE EXISTS (
442: SELECT 'Revenue recognition has been run'
443: FROM ra_customer_trx_lines
444: WHERE customer_trx_id = p_customer_trx_id

Line 515: FROM DUAL

511: SELECT DECODE( MAX(DUMMY),
512: NULL, 'N',
513: 'Y')
514: INTO l_temp_flag
515: FROM DUAL
516: WHERE EXISTS (
517: SELECT 'transaction has been posted'
518: FROM ar_transaction_history
519: WHERE customer_trx_id = p_customer_trx_id

Line 528: FROM DUAL

524: SELECT DECODE( MAX(DUMMY),
525: NULL, 'N',
526: 'Y')
527: INTO l_temp_flag
528: FROM DUAL
529: WHERE EXISTS (
530: SELECT 'transaction has been posted'
531: FROM ra_cust_trx_line_gl_dist
532: WHERE customer_trx_id = p_customer_trx_id

Line 1697: FROM DUAL

1693: SELECT DECODE( MAX(dummy),
1694: NULL, 'N',
1695: 'Y' )
1696: INTO l_commitments_exist_flag
1697: FROM DUAL
1698: WHERE EXISTS
1699: (
1700: SELECT 'commitments_exist'
1701: FROM hz_cust_accounts cust_acct,

Line 1724: from dual

1720: where cr.related_cust_account_id = p_bill_to_customer_id
1721: AND status = 'A'
1722: union
1723: select to_number(p_bill_to_customer_id)
1724: from dual
1725: UNION
1726: SELECT acc.cust_account_id
1727: FROM ar_paying_relationships_v rel,
1728: hz_cust_accounts acc

Line 1805: FROM DUAL

1801: SELECT DECODE( MAX(dummy),
1802: NULL, 'N',
1803: 'Y' )
1804: INTO l_agreements_exist_flag
1805: FROM DUAL
1806: WHERE EXISTS
1807: (
1808: SELECT 'agreements_exist'
1809: FROM so_agreements a

Line 1818: FROM dual

1814: WHERE cr.related_cust_account_id = p_bill_to_customer_id
1815: AND cr.status = 'A'
1816: UNION ALL
1817: SELECT to_number(p_bill_to_customer_id)
1818: FROM dual
1819: UNION ALL
1820: SELECT -1 /* no customer case */
1821: FROM dual
1822: )

Line 1821: FROM dual

1817: SELECT to_number(p_bill_to_customer_id)
1818: FROM dual
1819: UNION ALL
1820: SELECT -1 /* no customer case */
1821: FROM dual
1822: )
1823: AND p_trx_date
1824: BETWEEN NVL( TRUNC( a.start_date_active ), p_trx_date )
1825: AND NVL( TRUNC( a.end_date_active ), p_trx_date )

Line 2764: from dual;

2760: decode(p_bucket_category,
2761: 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0,
2762: 1)))
2763: into bucket_amount
2764: from dual;
2765:
2766: return(bucket_amount);
2767:
2768: END;

Line 3151: into l_curr from dual;

3147: p_cr_currency_code),
3148: p_inv_currency_code),
3149: p_cr_currency_code),
3150: 'CM',p_inv_currency_code)
3151: into l_curr from dual;
3152: return(l_curr);
3153: END GET_CURRENCY_CODE;
3154:
3155: END ARPT_SQL_FUNC_UTIL;