APPS.PA_PWP_INVOICE_REL dependencies on PA_PROJECTS

Line 56: FROM pa_projects prj

52: SELECT pdi.project_id
53: ,pdi.draft_invoice_num
54: ,EI.document_header_id AP_INVOICE_ID
55: ,'AUTOLINK' link_type
56: FROM pa_projects prj
57: , ra_customer_trx rac
58: , pa_draft_invoices pdi
59: , pa_draft_invoice_items pdii
60: , pa_cust_rev_dist_lines crdl

Line 105: FROM pa_projects prj

101: SELECT pwp.project_id
102: , pwp.draft_invoice_num
103: , pwp.AP_INVOICE_ID
104: ,'MANUAL' link_type
105: FROM pa_projects prj
106: , ra_customer_trx rac
107: , pa_draft_invoices pdi
108: , pa_pwp_linked_invoices pwp
109: WHERE prj.project_type = NVL(p_project_type ,prj.project_type)

Line 163: FROM pa_projects prj

159: )
160: THEN 'N'
161: ELSE 'Y'
162: END, 'Y') payment_status
163: FROM pa_projects prj
164: , ra_customer_trx rac
165: , pa_draft_invoices pdi
166: , pa_draft_invoice_items pdii
167: , pa_events pae

Line 212: ,PA_PROJECTS PROJ

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)
216: AND proj.AUTO_RELEASE_PWP_INV = 'Y'

Line 234: ,PA_PROJECTS PROJ

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
238: AND EI2.PROJECT_ID = PROJ.PROJECT_ID

Line 310: select min(pap.segment1) into start_project_num from pa_projects pap where project_type = nvl(p_project_type,pap.project_type) ;

306:
307:
308: if (p_proj_num is null) then
309: if ( P_from_proj_num is null ) then
310: select min(pap.segment1) into start_project_num from pa_projects pap where project_type = nvl(p_project_type,pap.project_type) ;
311: else
312: start_project_num := P_from_proj_num;
313: end if;
314: if (p_to_proj_num is null ) then

Line 315: select max(pap.segment1) into end_project_num from pa_projects pap where project_type = nvl(p_project_type,pap.project_type) ;

311: else
312: start_project_num := P_from_proj_num;
313: end if;
314: if (p_to_proj_num is null ) then
315: select max(pap.segment1) into end_project_num from pa_projects pap where project_type = nvl(p_project_type,pap.project_type) ;
316: else
317: end_project_num := p_to_proj_num;
318: end if;
319: else

Line 693: FROM pa_projects_all proj,

689: WHERE EXISTS
690: (
691: -- revnue generated but unbilled transactions exist for the AP Invoice
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

Line 722: pa_projects_all proj,

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
726: ei.DOCUMENT_HEADER_ID = p_invoice_id

Line 747: , PA_PROJECTS PRJ

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
748: , PA_TASKS TASK
749: , PA_TASKS TOPTASK
750: WHERE EI.PROJECT_ID = TASK.PROJECT_ID
751: AND EI.TASK_ID = TASK.TASK_ID

Line 789: FROM PA_PROJECTS PRJ

785: )
786: OR exists
787: -- unpaid manually linked invoices exist
788: (SELECT 1
789: FROM PA_PROJECTS PRJ
790: , PA_DRAFT_INVOICES PDI
791: , PA_PWP_LINKED_INVOICES PWP
792: WHERE PRJ.PROJECT_ID = PDI.PROJECT_ID
793: AND PDI.PROJECT_ID = PWP.PROJECT_ID -- Bug 7720228

Line 864: -- Note : Checks if PA_PROJECTS_ALL.AUTO_RELEASE_PWP_INV is Y/N.

860: -- Function : is_eligible
861: -- Type :Private
862: -- Purpose : To find if all AUTO_RELEASE_PWP_INV is yes for all
863: -- related projects.
864: -- Note : Checks if PA_PROJECTS_ALL.AUTO_RELEASE_PWP_INV is Y/N.
865: -- Assumptions :
866: -- Parameter :
867: -- Parameters Type Required Description and Purpose
868: -- --------------------------- ------ -------- --------------------------------------------------------

Line 884: pa_projects proj,

880: SELECT 'N' into v_tmp
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