APPS.PA_PWP_INVOICE_REL dependencies on PA_EXPENDITURE_ITEMS

Line 41: TYPE IdsTab IS TABLE OF PA_EXPENDITURE_ITEMS.DOCUMENT_HEADER_ID%TYPE;

37: l_msg_data VARCHAR2(100);
38: p_error_message_code VARCHAR2(2000);
39: xml_layout BOOLEAN;
40:
41: TYPE IdsTab IS TABLE OF PA_EXPENDITURE_ITEMS.DOCUMENT_HEADER_ID%TYPE;
42: l_unbill_invids IdsTab;
43:
44:
45:

Line 58: pa_expenditure_items ei ,

54: FROM pa_projects prj ,
55: pa_draft_invoices pdi ,
56: pa_draft_invoice_items pdii ,
57: pa_cust_rev_dist_lines crdl ,
58: pa_expenditure_items ei ,
59: ( select distinct invoice_id
60: from ap_holds_all
61: where hold_lookup_code = 'Pay When Paid'
62: and release_reason is null ) AHA ----- Alias query added for bug#12404156

Line 205: FROM PA_EXPENDITURE_ITEMS EI

201: falls in the criteria specified for the concurrent program.
202: */
203: CURSOR cur_inv_unbillable IS
204: SELECT /*+ leading(aha) */ DISTINCT EI.DOCUMENT_HEADER_ID -- leading Hint Added for bug#12404156
205: FROM PA_EXPENDITURE_ITEMS EI
206: ,PA_PROJECTS PROJ
207: ,PA_TASKS TASK
208: ,PA_TASKS TOPTASK
209: ,

Line 231: (SELECT /*+ INDEX(EI2 PA_EXPENDITURE_ITEMS_N27)*/

227: AND TASK.TOP_TASK_ID = TOPTASK.TASK_ID
228: AND TOPTASK.PROJECT_ID = EI.PROJECT_ID
229: AND DECODE(PROJ.ENABLE_TOP_TASK_INV_MTH_FLAG, 'Y', TOPTASK.INVOICE_METHOD,PROJ.INVOICE_METHOD) = 'WORK'
230: AND NOT EXISTS
231: (SELECT /*+ INDEX(EI2 PA_EXPENDITURE_ITEMS_N27)*/
232: 1
233: FROM PA_EXPENDITURE_ITEMS EI2
234: ,PA_PROJECTS PROJ
235: ,PA_TASKS TASK

Line 233: FROM PA_EXPENDITURE_ITEMS EI2

229: AND DECODE(PROJ.ENABLE_TOP_TASK_INV_MTH_FLAG, 'Y', TOPTASK.INVOICE_METHOD,PROJ.INVOICE_METHOD) = 'WORK'
230: AND NOT EXISTS
231: (SELECT /*+ INDEX(EI2 PA_EXPENDITURE_ITEMS_N27)*/
232: 1
233: FROM PA_EXPENDITURE_ITEMS EI2
234: ,PA_PROJECTS PROJ
235: ,PA_TASKS TASK
236: ,PA_TASKS TOPTASK
237: WHERE EI2.DOCUMENT_HEADER_ID =EI.DOCUMENT_HEADER_ID

Line 699: pa_expenditure_items ei,

695: SELECT 1
696: FROM pa_projects_all proj,
697: pa_tasks task,
698: pa_tasks toptask,
699: pa_expenditure_items ei,
700: pa_cust_rev_dist_lines crdl
701: WHERE proj.project_id = task.project_id
702: and task.top_task_id = toptask.task_id
703: and toptask.project_id = ei.project_id

Line 724: pa_expenditure_items ei ,

720: (
721: -- Pending revenue generation
722: SELECT 1
723: FROM
724: pa_expenditure_items ei ,
725: pa_projects_all proj,
726: pa_tasks task,
727: pa_tasks toptask
728: WHERE

Line 747: FROM PA_EXPENDITURE_ITEMS EI

743: OR exists
744: --Any invoices that are not interfaced to AR or interfaced but unpaid in AR
745: (
746: SELECT 1
747: FROM PA_EXPENDITURE_ITEMS EI
748: , PA_CUST_REV_DIST_LINES CRDL
749: , PA_DRAFT_INVOICE_ITEMS PDII
750: , PA_DRAFT_INVOICES PDI
751: , PA_PROJECTS PRJ

Line 893: pa_expenditure_items_all ei

889: FROM dual
890: WHERE EXISTS
891: ( select 1 from
892: pa_projects proj,
893: pa_expenditure_items_all ei
894: where
895: ei.project_id = proj.project_id and
896: ei.document_header_id = p_invoice_id and
897: proj.AUTO_RELEASE_PWP_INV = 'N' );