APPS.PA_BILL_WORKBENCH_INVOICE dependencies on PA_DRAFT_INVOICES_ALL

Line 38: FROM pa_draft_invoices_all

34:
35: /*
36: Cursor related_Inv_Cur is
37: select to_char(draft_invoice_num) draft_inv_num
38: FROM pa_draft_invoices_all
39: WHERE project_id = P_Project_ID
40: AND invoice_set_id = (select invoice_set_id from
41: pa_draft_invoices_all
42: where draft_invoice_num = p_draft_inv_num

Line 41: pa_draft_invoices_all

37: select to_char(draft_invoice_num) draft_inv_num
38: FROM pa_draft_invoices_all
39: WHERE project_id = P_Project_ID
40: AND invoice_set_id = (select invoice_set_id from
41: pa_draft_invoices_all
42: where draft_invoice_num = p_draft_inv_num
43: and project_id = p_project_id)
44: and nvl(customer_bill_split,0) not in (0,100);
45: */

Line 216: FROM PA_Draft_Invoices_ALL i

212: /* check for multi customer invoices */
213:
214: SELECT count(*)
215: INTO l_dummy
216: FROM PA_Draft_Invoices_ALL i
217: WHERE i.invoice_set_id = (select invoice_set_id from pa_draft_invoices_all
218: where project_id = p_project_id
219: and draft_invoice_num = p_draft_inv_num)
220: AND i.customer_bill_split not in (0, 100)

Line 217: WHERE i.invoice_set_id = (select invoice_set_id from pa_draft_invoices_all

213:
214: SELECT count(*)
215: INTO l_dummy
216: FROM PA_Draft_Invoices_ALL i
217: WHERE i.invoice_set_id = (select invoice_set_id from pa_draft_invoices_all
218: where project_id = p_project_id
219: and draft_invoice_num = p_draft_inv_num)
220: AND i.customer_bill_split not in (0, 100)
221: AND i.approved_date is null

Line 291: FROM pa_draft_invoices_all

287:
288:
289: SELECT approved_date
290: INTO l_approved_date
291: FROM pa_draft_invoices_all
292: WHERE project_id = p_project_id
293: AND draft_invoice_num = p_draft_invoice_num;
294:
295:

Line 303: UPDATE pa_draft_invoices_all

299:
300:
301: IF (l_approved_date is null ) THEN
302:
303: UPDATE pa_draft_invoices_all
304: SET last_update_date = sysdate,
305: Last_updated_by = p_user_id,
306: last_update_login = p_login_id,
307: approved_date = TRUNC(sysdate),

Line 435: FROM pa_draft_invoices_all i, /* changed the refrence to base table instead of pa_draft_invoices_all_v for bug # 4666256 */

431: Cursor Inv_Cur is
432:
433: SELECT i.customer_id, i.generation_error_flag,
434: i.approved_date , p.project_status_code
435: FROM pa_draft_invoices_all i, /* changed the refrence to base table instead of pa_draft_invoices_all_v for bug # 4666256 */
436: pa_projects_all p /* added the refrence to pa_projects_all for project_status_code */
437: WHERE i.project_id = P_Project_ID
438: AND p.project_id = i.project_id
439: AND i.draft_invoice_num = P_Draft_Invoice_Num;

Line 536: FROM PA_Draft_Invoices_ALL i

532: l_dummy := 0;
533:
534: SELECT count(*)
535: INTO l_dummy
536: FROM PA_Draft_Invoices_ALL i
537: WHERE i.invoice_set_id = P_Invoice_Set_ID
538: AND i.customer_bill_split not in (0, 100)
539: AND i.approved_date is null;
540:

Line 566: FROM pa_draft_invoices_all --For Bug 3961053

562: l_fst_flag varchar2(1);
563:
564: Cursor Inv_Cur is
565: SELECT project_id, draft_invoice_num, customer_id, approved_date
566: FROM pa_draft_invoices_all --For Bug 3961053
567: -- FROM pa_draft_invoices_all_v --For Bug 3961053
568: WHERE project_id = P_Project_ID
569: AND invoice_set_id = P_invoice_set_id
570: and nvl(customer_bill_split,0) not in (0,100);

Line 567: -- FROM pa_draft_invoices_all_v --For Bug 3961053

563:
564: Cursor Inv_Cur is
565: SELECT project_id, draft_invoice_num, customer_id, approved_date
566: FROM pa_draft_invoices_all --For Bug 3961053
567: -- FROM pa_draft_invoices_all_v --For Bug 3961053
568: WHERE project_id = P_Project_ID
569: AND invoice_set_id = P_invoice_set_id
570: and nvl(customer_bill_split,0) not in (0,100);
571:

Line 656: FROM pa_draft_invoices_all

652: l_app_draft_num varchar2(30);
653:
654: Cursor unappr_cur is
655: select draft_invoice_num
656: FROM pa_draft_invoices_all
657: WHERE project_id = P_Project_ID
658: AND invoice_set_id = p_invoice_set_id
659: and nvl(customer_bill_split,0) not in (0,100);
660:

Line 680: FROM pa_draft_invoices_all

676:
677:
678: SELECT count(*)
679: INTO l_approved_count
680: FROM pa_draft_invoices_all
681: WHERE project_id = p_project_id
682: AND invoice_set_id = p_invoice_set_id
683: AND approved_date is not null
684: AND nvl(customer_bill_split,0) not in (0,100);

Line 701: UPDATE pa_draft_invoices_all

697: l_app_draft_num := l_app_draft_num ||',';
698: end if;
699: l_app_draft_num := l_app_draft_num || trim(to_char(unappr_rec.draft_invoice_num));
700:
701: UPDATE pa_draft_invoices_all
702: SET last_update_date = sysdate,
703: Last_updated_by = p_user_id,
704: last_update_login = p_login_id,
705: approved_date = TRUNC(sysdate),