DBA Data[Home] [Help]

APPS.PA_MC_CURRENCY_PKG dependencies on PA_DRAFT_INVOICE_DETAILS_ALL

Line 1263: pa_draft_invoice_details_all dii

1259:
1260: SELECT sum(nvl(mcdii.bill_amount,0))
1261: INTO ic_rdl_amt
1262: FROM pa_mc_draft_inv_details_all mcdii ,
1263: pa_draft_invoice_details_all dii
1264: WHERE dii.project_id = x_project_id
1265: AND dii.draft_invoice_num = x_di_num
1266: AND dii.draft_invoice_line_num = x_line_num
1267: AND dii.draft_invoice_detail_id = mcdii.draft_invoice_detail_id

Line 2034: from pa_draft_invoice_details_all

2030: FROM pa_mc_draft_inv_details_all
2031: WHERE set_of_books_id = x_set_of_books_id
2032: AND draft_invoice_detail_id in
2033: (select draft_invoice_detail_id
2034: from pa_draft_invoice_details_all
2035: where expenditure_item_id = x_exp_item_id) ;
2036:
2037: l_old_stack Varchar2(2000);
2038: