DBA Data[Home] [Help]

APPS.AR_ADJUST_PUB dependencies on AR_ACTIVITY_DETAILS

Line 2887: | Do not continue if exist AR_ACTIVITY_DETAILS. |

2883: END ;
2884:
2885: /*------------------------------------------+
2886: | Validate for Line level |
2887: | Do not continue if exist AR_ACTIVITY_DETAILS. |
2888: +------------------------------------------*/
2889:
2890: BEGIN
2891: Select count(*)

Line 2893: from AR_ACTIVITY_DETAILS

2889:
2890: BEGIN
2891: Select count(*)
2892: into l_count_chk
2893: from AR_ACTIVITY_DETAILS
2894: where source_id = p_old_adjust_id
2895: and source_table = 'ADJ'
2896: and nvl(CURRENT_ACTIVITY_FLAG,'Y') = 'Y' -- Bug 7241111
2897: and customer_trx_line_id = l_old_adj_rec.customer_trx_line_id;

Line 3415: from AR_ACTIVITY_DETAILS

3411:
3412: BEGIN
3413: Select count(*)
3414: into l_count_chk
3415: from AR_ACTIVITY_DETAILS
3416: where source_id = p_old_adjust_id
3417: and source_table = 'ADJ'
3418: and nvl(CURRENT_ACTIVITY_FLAG,'Y') = 'Y' -- Bug 7241111
3419: and customer_trx_line_id = l_adj_rec.customer_trx_line_id;