APPS.AR_CM_APP_LIB_PVT dependencies on AR_RECEIVABLE_APPLICATIONS

Line 315: FROM ar_receivable_applications

311:
312: BEGIN
313: SELECT receivable_application_id, gl_date
314: INTO l_rec_appln_id , p_apply_gl_date
315: FROM ar_receivable_applications
316: WHERE customer_trx_id = p_customer_trx_id
317: AND display = 'Y'
318: AND applied_payment_schedule_id = -8
319: AND status = 'ACTIVITY';

Line 341: FROM ar_receivable_applications

337:
338: BEGIN
339: SELECT customer_trx_id, gl_date
340: INTO l_customer_trx_id , p_apply_gl_date
341: FROM ar_receivable_applications
342: WHERE receivable_application_id = p_receivable_application_id
343: and display = 'Y'
344: and applied_payment_schedule_id = -8
345: and status = 'ACTIVITY';

Line 433: FROM ar_receivable_applications

429: IF p_receivable_application_id IS NOT NULL THEN
430: BEGIN
431: SELECT customer_trx_id
432: INTO l_customer_trx_id
433: FROM ar_receivable_applications
434: WHERE receivable_application_id = p_receivable_application_id
435: AND applied_payment_schedule_id = -8
436: AND status = 'ACTIVITY'
437: and display = 'Y';

Line 448: FROM ar_receivable_applications

444: ELSIF p_customer_trx_id IS NOT NULL THEN
445: BEGIN
446: SELECT receivable_application_id
447: INTO l_rec_appln_id
448: FROM ar_receivable_applications
449: WHERE customer_trx_id = p_customer_trx_id
450: AND applied_payment_schedule_id = -8
451: AND display = 'Y'
452: AND status = 'ACTIVITY';