APPS.PA_IC_INV_UTILS dependencies on PA_DRAFT_INVOICE_DETAILS

Line 209: Update pa_draft_invoice_details

205: last_update_login = l_user_id
206: where project_id = P_Project_Id
207: and draft_invoice_num = l_err_invoice_num;
208:
209: Update pa_draft_invoice_details
210: set draft_invoice_num = l_new_invoice_num,
211: last_update_date = SYSDATE,
212: last_update_login = l_user_id
213: where project_id = P_Project_Id

Line 466: from pa_draft_invoice_details did

462: ind_compiled_set_id tp_ind_compiled_set_id,
463: bill_rate tp_bill_rate,
464: bill_markup_percentage tp_bill_markup_percentage,
465: schedule_line_percentage tp_schedule_line_percentage
466: from pa_draft_invoice_details did
467: where did.project_id = P_PROJECT_ID
468: and did.request_id = P_REQUEST_ID
469: and did.draft_invoice_num = P_DRAFT_INVOICE_NUM
470: and did.line_num = ( select max(did1.line_num)

Line 471: from pa_draft_invoice_details did1

467: where did.project_id = P_PROJECT_ID
468: and did.request_id = P_REQUEST_ID
469: and did.draft_invoice_num = P_DRAFT_INVOICE_NUM
470: and did.line_num = ( select max(did1.line_num)
471: from pa_draft_invoice_details did1
472: where did1.expenditure_item_id =
473: did.expenditure_item_id)
474: ;
475:

Line 594: FROM PA_DRAFT_INVOICE_DETAILS DID

590:
591:
592: CURSOR C_UNREL_INV_BY_PROJECT IS
593: SELECT 'x'
594: FROM PA_DRAFT_INVOICE_DETAILS DID
595: WHERE DID.PROJECT_ID = P_PROJECT_ID
596: AND DID.INVOICED_FLAG = 'N'
597: AND NOT EXISTS
598: ( SELECT 'X'