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 1663: from pa_projects_all

1659: -- bug : 3617328 perf issue in gmspax1b.pls
1660: --
1661: cursor c_get_project_id is
1662: select project_id
1663: from pa_projects_all
1664: where segment1 = l_project_number ;
1665:
1666: --
1667: -- bug : 3617328 perf issue in gmspax1b.pls

Line 1671: from pa_projects_all

1667: -- bug : 3617328 perf issue in gmspax1b.pls
1668: --
1669: cursor c_get_project_num is
1670: select segment1
1671: from pa_projects_all
1672: where project_id = l_project_id ;
1673:
1674: --
1675: -- bug : 3617328 perf issue in gmspax1b.pls

Line 2245: pa_projects_all p,

2241:
2242: select nvl(sponsored_flag,'N')
2243: into l_sponsored_flag
2244: from pa_tasks t,
2245: pa_projects_all p,
2246: gms_project_types gpt
2247: where p.project_id = t.project_id
2248: and gpt.project_type = p.project_type
2249: and t.task_id = nvl(p_task_id,0);

Line 2444: l_project_id pa_projects_all.project_id%TYPE ;

2440: 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
2441:
2442: l_award_status gms_awards_all.status%TYPE ;
2443: l_close_date gms_awards_all.close_date%TYPE ;
2444: l_project_id pa_projects_all.project_id%TYPE ;
2445:
2446: Begin
2447:
2448: select aw.status, aw.close_date