APPS.GMS_FUNDS_CONTROL_PKG dependencies on PA_PROJECTS_ALL

Line 102: pa_projects_all pp

98: BEGIN
99: Select nvl(gpt.sponsored_flag,'N')
100: into x_sponsored_flag
101: from gms_project_types gpt,
102: pa_projects_all pp
103: where pp.project_id = p_project_id
104: and gpt.project_type = pp.project_type;
105: RETURN x_sponsored_flag;
106: END sponsored_project;

Line 2240: pa_projects_all pp

2236: FROM po_bc_distributions pobc ,
2237: psa_bc_xla_events_gt xlaevt,
2238: pa_expenditure_types et,
2239: gms_project_types gpt,
2240: pa_projects_all pp
2241: WHERE pobc.ae_event_id = xlaevt.event_id
2242: AND pobc.pa_project_id IS NOT NULL
2243: AND pobc.pa_project_id = pp.project_id
2244: AND pp.project_type = gpt.project_type

Line 2259: pa_projects_all pp,

2255: /* Bug 5645290 - End */
2256: FROM psa_bc_xla_events_gt xlaevt,
2257: ap_invoice_distributions_all apd,
2258: gms_project_types gpt,
2259: pa_projects_all pp,
2260: ap_invoices_all apinv
2261: WHERE apd.bc_event_id = xlaevt.event_id
2262: AND apd.project_id IS NOT NULL
2263: AND apinv.invoice_id = apd.invoice_id

Line 4146: FROM pa_projects_all

4142: SELECT start_date,
4143: completion_date
4144: INTO project_start_date,
4145: project_end_date
4146: FROM pa_projects_all
4147: WHERE project_id = x_project_id;
4148:
4149: -- Added for GMS enhancements : Bug : 5583170
4150: -- If time pjhase code is date range then