DBA Data[Home] [Help]

APPS.JE_IT_INVOICES_ABOVE_THRESHOLD dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 982: FROM ar_receivable_applications_all

978: IF p_parent_trx_id IS NULL THEN
979:
980: SELECT count(*)
981: INTO l_count
982: FROM ar_receivable_applications_all
983: WHERE customer_trx_id = p_cust_trx_id;
984:
985: IF (l_count = 0 or l_count > 1) Then
986: l_orig_trx_id := NULL;

Line 990: FROM ar_receivable_applications_all

986: l_orig_trx_id := NULL;
987: ELSE
988: SELECT applied_customer_trx_id
989: INTO l_orig_trx_id
990: FROM ar_receivable_applications_all
991: WHERE customer_trx_id = p_cust_trx_id;
992: END IF;
993: ELSE
994: l_orig_trx_id :=p_parent_trx_id;