APPS.JL_AR_AP_AWT_REPORTS_PKG dependencies on JL_AR_AP_AWT_CERTIF_ALL

Line 473: l_log_msg := 'Inserting into jl_ar_ap_awt_certif_all table ';

469:
470:
471: -- Logging Infra: Statement level
472: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
473: l_log_msg := 'Inserting into jl_ar_ap_awt_certif_all table ';
474: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
475: END IF;
476: -- Logging Infra: Statement level
477:

Line 479: INSERT INTO jl_ar_ap_awt_certif_all

475: END IF;
476: -- Logging Infra: Statement level
477:
478:
479: INSERT INTO jl_ar_ap_awt_certif_all
480: (certificate_id ,
481: certificate_number ,
482: bank_account_num ,
483: payment_document_name ,

Line 708: FROM jl_ar_ap_awt_certif_all jaaac1

704:
705:
706: SELECT jaaac1.certificate_number
707: INTO max_number
708: FROM jl_ar_ap_awt_certif_all jaaac1
709: WHERE jaaac1.awt_type_code = p_awt_type_code
710: AND jaaac1.org_id = x_org_id --bug 14798548
711: AND jaaac1.certificate_number = (select max(jaaac2.certificate_number)
712: from jl_ar_ap_awt_certif_all jaaac2

Line 712: from jl_ar_ap_awt_certif_all jaaac2

708: FROM jl_ar_ap_awt_certif_all jaaac1
709: WHERE jaaac1.awt_type_code = p_awt_type_code
710: AND jaaac1.org_id = x_org_id --bug 14798548
711: AND jaaac1.certificate_number = (select max(jaaac2.certificate_number)
712: from jl_ar_ap_awt_certif_all jaaac2
713: where jaaac2.awt_type_code = p_awt_type_code
714: and jaaac2.org_id = x_org_id ) --bug 14798548
715: FOR UPDATE;
716: