APPS.JL_AR_AP_AWT_REPORTS_PKG dependencies on JL_AR_AP_AWT_CERTIF_ALL

Line 340: INSERT INTO jl_ar_ap_awt_certif_all

336: --Bug 6504015. added code for setting the org-id while insert.
337: v_org_id := MO_GLOBAL.get_current_org_id;
338: --in certificates we insert now for r12 payment id rather than check id
339:
340: INSERT INTO jl_ar_ap_awt_certif_all
341: (certificate_id ,
342: certificate_number ,
343: bank_account_num ,
344: payment_document_name ,

Line 467: FROM jl_ar_ap_awt_certif_all jaaac1

463:
464:
465: SELECT jaaac1.certificate_number
466: INTO max_number
467: FROM jl_ar_ap_awt_certif_all jaaac1
468: WHERE jaaac1.awt_type_code = p_awt_type_code
469: AND jaaac1.certificate_number = (select max(jaaac2.certificate_number)
470: from jl_ar_ap_awt_certif_all jaaac2
471: where jaaac2.awt_type_code = p_awt_type_code)

Line 470: from jl_ar_ap_awt_certif_all jaaac2

466: INTO max_number
467: FROM jl_ar_ap_awt_certif_all jaaac1
468: WHERE jaaac1.awt_type_code = p_awt_type_code
469: AND jaaac1.certificate_number = (select max(jaaac2.certificate_number)
470: from jl_ar_ap_awt_certif_all jaaac2
471: where jaaac2.awt_type_code = p_awt_type_code)
472: FOR UPDATE;
473:
474: