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

368: SELECT DECODE( MAX(DUMMY),
369: NULL, 'N',
370: 'Y')
371: INTO l_temp_flag
372: FROM DUAL
373: WHERE EXISTS (
374: SELECT 'Revenue recognition has been run'
375: FROM ra_customer_trx_lines
376: WHERE customer_trx_id = p_customer_trx_id

Line 447: FROM DUAL

443: SELECT DECODE( MAX(DUMMY),
444: NULL, 'N',
445: 'Y')
446: INTO l_temp_flag
447: FROM DUAL
448: WHERE EXISTS (
449: SELECT 'transaction has been posted'
450: FROM ar_transaction_history
451: WHERE customer_trx_id = p_customer_trx_id

Line 460: FROM DUAL

456: SELECT DECODE( MAX(DUMMY),
457: NULL, 'N',
458: 'Y')
459: INTO l_temp_flag
460: FROM DUAL
461: WHERE EXISTS (
462: SELECT 'transaction has been posted'
463: FROM ra_cust_trx_line_gl_dist
464: WHERE customer_trx_id = p_customer_trx_id

Line 1607: FROM DUAL

1603: SELECT DECODE( MAX(dummy),
1604: NULL, 'N',
1605: 'Y' )
1606: INTO l_commitments_exist_flag
1607: FROM DUAL
1608: WHERE EXISTS
1609: (
1610: SELECT 'commitments_exist'
1611: FROM hz_cust_accounts cust_acct,

Line 1634: from dual

1630: where cr.related_cust_account_id = p_bill_to_customer_id
1631: AND status = 'A'
1632: union
1633: select to_number(p_bill_to_customer_id)
1634: from dual
1635: UNION
1636: SELECT acc.cust_account_id
1637: FROM ar_paying_relationships_v rel,
1638: hz_cust_accounts acc

Line 1715: FROM DUAL

1711: SELECT DECODE( MAX(dummy),
1712: NULL, 'N',
1713: 'Y' )
1714: INTO l_agreements_exist_flag
1715: FROM DUAL
1716: WHERE EXISTS
1717: (
1718: SELECT 'agreements_exist'
1719: FROM so_agreements a

Line 1728: FROM dual

1724: WHERE cr.related_cust_account_id = p_bill_to_customer_id
1725: AND cr.status = 'A'
1726: UNION ALL
1727: SELECT to_number(p_bill_to_customer_id)
1728: FROM dual
1729: UNION ALL
1730: SELECT -1 /* no customer case */
1731: FROM dual
1732: )

Line 1731: FROM dual

1727: SELECT to_number(p_bill_to_customer_id)
1728: FROM dual
1729: UNION ALL
1730: SELECT -1 /* no customer case */
1731: FROM dual
1732: )
1733: AND p_trx_date
1734: BETWEEN NVL( TRUNC( a.start_date_active ), p_trx_date )
1735: AND NVL( TRUNC( a.end_date_active ), p_trx_date )

Line 2645: from dual;

2641: decode(p_bucket_category,
2642: 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0,
2643: 1)))
2644: into bucket_amount
2645: from dual;
2646:
2647: return(bucket_amount);
2648:
2649: END;

Line 3031: into l_curr from dual;

3027: p_cr_currency_code),
3028: p_inv_currency_code),
3029: p_cr_currency_code),
3030: 'CM',p_inv_currency_code)
3031: into l_curr from dual;
3032: return(l_curr);
3033: END GET_CURRENCY_CODE;
3034:
3035: END ARPT_SQL_FUNC_UTIL;