DBA Data[Home] [Help]

APPS.PA_INVOICE_TIEBACK dependencies on PA_DRAFT_INVOICE_ITEMS

Line 19: FROM pa_draft_invoice_items dii

15: l_project_id number)
16: Is
17: SELECT dii.acct_amount acct_amt,
18: dii.line_num line_num
19: FROM pa_draft_invoice_items dii
20: WHERE dii.project_id = l_project_id
21: AND dii.draft_invoice_num = l_draft_inv_num;
22:
23: Cursor cur_get_ar_amt ( l_project_num VARCHAR2,