DBA Data[Home] [Help]

APPS.PON_EMD_AR_INTEGRATION_GRP dependencies on AR_RECEIVABLES_TRX_ALL

Line 871: FROM ar_receivables_trx_all

867: IF (l_applied_payment_schedule_id = -8 ) THEN
868: BEGIN
869: SELECT RECEIVABLES_TRX_ID
870: INTO l_receivables_trx_id
871: FROM ar_receivables_trx_all
872: WHERE status = 'A' AND
873: TYPE ='CM_REFUND'AND ORG_ID = l_org_id;
874: EXCEPTION
875: WHEN No_Data_Found THEN

Line 886: FROM ar_receivables_trx_all

882: ELSIF(l_applied_payment_schedule_id = -6 ) THEN
883: BEGIN
884: SELECT RECEIVABLES_TRX_ID
885: INTO l_receivables_trx_id
886: FROM ar_receivables_trx_all
887: WHERE status = 'A' AND
888: TYPE ='CCREFUND'AND ORG_ID = l_org_id;
889: EXCEPTION
890: WHEN No_Data_Found THEN