APPS.GMS_PA_API dependencies on PA_PROJECTS

Line 157: and exists (select 1 from pa_project_types t, pa_projects pa

153: -- Start, Bug 1756179
154: update pa_expenditure_items_all
155: set billable_flag = x_billable_flag
156: where expenditure_item_id = new_rec.expenditure_item_id
157: and exists (select 1 from pa_project_types t, pa_projects pa
158: where pa.project_id = SOURCE_PROJECT_ID
159: and pa.project_type=t.project_type
160: and t.Project_type_class_code= 'INDIRECT');
161: -- End, Bug 1756179

Line 509: FROM pa_projects_all P,

505: x_return BOOLEAN ;
506:
507: CURSOR C_SPONSORED IS
508: select 'X'
509: FROM pa_projects_all P,
510: gms_project_types gpt
511: WHERE p.project_id = X_project_id
512: AND p.project_type = gpt.project_type
513: and gpt.sponsored_flag = 'Y' ;

Line 1523: l_project_number pa_projects_all.segment1%TYPE ;

1519: -- bug : 3617328 perf issue in gmspax1b.pls
1520: --
1521: l_project_id number ;
1522: l_task_id number ;
1523: l_project_number pa_projects_all.segment1%TYPE ;
1524: l_task_number pa_tasks.task_number%TYPE ;
1525: x_outcome VARCHAR2(2000) ;
1526: l_gl_accted_flag VARCHAR2(1) ;
1527: l_bud_ver_id NUMBER ;

Line 1650: from pa_projects_all

1646: -- bug : 3617328 perf issue in gmspax1b.pls
1647: --
1648: cursor c_get_project_id is
1649: select project_id
1650: from pa_projects_all
1651: where segment1 = l_project_number ;
1652:
1653: --
1654: -- bug : 3617328 perf issue in gmspax1b.pls

Line 1658: from pa_projects_all

1654: -- bug : 3617328 perf issue in gmspax1b.pls
1655: --
1656: cursor c_get_project_num is
1657: select segment1
1658: from pa_projects_all
1659: where project_id = l_project_id ;
1660:
1661: --
1662: -- bug : 3617328 perf issue in gmspax1b.pls

Line 2232: pa_projects_all p,

2228:
2229: select nvl(sponsored_flag,'N')
2230: into l_sponsored_flag
2231: from pa_tasks t,
2232: pa_projects_all p,
2233: gms_project_types gpt
2234: where p.project_id = t.project_id
2235: and gpt.project_type = p.project_type
2236: and t.task_id = nvl(p_task_id,0);

Line 2393: l_project_id pa_projects_all.project_id%TYPE ;

2389: FUNCTION is_award_closed (x_expenditure_item_id IN NUMBER ,x_task_id IN NUMBER ,x_doc_type in varchar2 default 'EXP') return VARCHAR2 IS --Bug 5726575
2390:
2391: l_award_status gms_awards_all.status%TYPE ;
2392: l_close_date gms_awards_all.close_date%TYPE ;
2393: l_project_id pa_projects_all.project_id%TYPE ;
2394:
2395: Begin
2396:
2397: select aw.status, aw.close_date