DBA Data[Home] [Help]

APPS.ARP_CORRECT_CC_ERRORS dependencies on FND_CONCURRENT_REQUESTS

Line 1674: from fnd_concurrent_requests

1670: FROM dual
1671: WHERE EXISTS (SELECT 1
1672: FROM ar_cash_receipts
1673: WHERE request_id IN ( select request_id
1674: from fnd_concurrent_requests
1675: where request_id = p_request_id
1676: or parent_request_id = p_request_id )
1677: AND cc_error_flag = 'Y');
1678: EXCEPTION

Line 1695: from fnd_concurrent_requests

1691: FROM dual
1692: WHERE EXISTS (SELECT 1
1693: FROM ra_customer_trx
1694: WHERE request_id IN ( select request_id
1695: from fnd_concurrent_requests
1696: where request_id = p_request_id
1697: or parent_request_id = p_request_id )
1698: AND cc_error_flag = 'Y');
1699: EXCEPTION

Line 1756: from fnd_concurrent_requests

1752: cc_error_text,
1753: request_id
1754: FROM ar_cash_receipts
1755: WHERE request_id IN ( select request_id
1756: from fnd_concurrent_requests
1757: where request_id = p_request_id
1758: or parent_request_id = p_request_id )
1759: AND cc_error_flag = 'Y'
1760: AND cc_error_code IS NOT NULL;

Line 1884: from fnd_concurrent_requests

1880: FROM ra_customer_trx trx,
1881: ra_cust_trx_types trx_type
1882: WHERE trx.cust_trx_type_id = trx_type.cust_trx_type_id
1883: AND trx.request_id IN ( select request_id
1884: from fnd_concurrent_requests
1885: where request_id = p_request_id
1886: or parent_request_id = p_request_id )
1887: AND trx.cc_error_flag = 'Y'
1888: AND cc_error_code IS NOT NULL;

Line 2505: from fnd_concurrent_requests

2501: CURSOR lock_cr IS
2502: SELECT 'lock'
2503: FROM ar_cash_receipts
2504: WHERE request_id IN ( select request_id
2505: from fnd_concurrent_requests
2506: where request_id = p_request_id
2507: or parent_request_id = p_request_id )
2508: AND cc_error_flag = 'Y'
2509: AND cc_error_code IS NOT NULL

Line 2515: from fnd_concurrent_requests

2511: CURSOR lock_trx IS
2512: SELECT 'lock'
2513: FROM ra_customer_trx
2514: WHERE request_id IN ( select request_id
2515: from fnd_concurrent_requests
2516: where request_id = p_request_id
2517: or parent_request_id = p_request_id )
2518: AND cc_error_flag = 'Y'
2519: AND cc_error_code IS NOT NULL