DBA Data[Home] [Help]

APPS.JA_CN_AP_PBD_EXPORT_PKG dependencies on AP_INVOICES_V

Line 678: FROM Ap_Invoices_v

674: AND Gp.Period_Name = lv_period_name; --variable: lv_period_name
675:
676: CURSOR inv_period_name_cur IS
677: SELECT Period_Name
678: FROM Ap_Invoices_v
679: WHERE Invoice_Id = pn_invoice_id; --parameter: pn_invoice_id
680:
681: BEGIN
682: --logging for debug

Line 3145: FROM Ap_Invoices_v

3141: 'N', --it is not a prepayment invoice or current period is not the one prepayment created in
3142: 'Y'), --it is a prepayment invoice and current period is the one prepayment created in
3143: 'N') --prepaid line has been exported
3144: INTO lv_prepay_export_flag
3145: FROM Ap_Invoices_v
3146: WHERE Invoice_Id = v_inv_id_row.Invoice_Id
3147: AND Period_Name = v_period_name_row.period_name
3148: AND Invoice_Type_Lookup_Code = 'PREPAYMENT';
3149: