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 61: , pa_expenditure_items ei

57: , ra_customer_trx rac
58: , pa_draft_invoices pdi
59: , pa_draft_invoice_items pdii
60: , pa_cust_rev_dist_lines crdl
61: , pa_expenditure_items ei
62: WHERE prj.project_type = NVL(p_project_type ,prj.project_type)
63: AND prj.AUTO_RELEASE_PWP_INV = 'Y'
64: AND prj.segment1 BETWEEN start_project_num AND end_project_num
65: AND prj.project_id = pdi.project_id

Line 211: FROM PA_EXPENDITURE_ITEMS EI

207: falls in the criteria specified for the concurrent program.
208: */
209: CURSOR cur_inv_unbillable IS
210: SELECT DISTINCT EI.DOCUMENT_HEADER_ID
211: FROM PA_EXPENDITURE_ITEMS EI
212: ,PA_PROJECTS PROJ
213: ,PA_TASKS TASK
214: ,PA_TASKS TOPTASK
215: WHERE proj.project_type = NVL(p_project_type ,proj.project_type)

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 696: pa_expenditure_items ei,

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

Line 721: pa_expenditure_items ei ,

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

Line 743: FROM PA_EXPENDITURE_ITEMS EI

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

Line 885: pa_expenditure_items_all ei

881: FROM dual
882: WHERE EXISTS
883: ( select 1 from
884: pa_projects proj,
885: pa_expenditure_items_all ei
886: where
887: ei.project_id = proj.project_id and
888: ei.document_header_id = p_invoice_id and
889: proj.AUTO_RELEASE_PWP_INV = 'N' );