APPS.GMS_FUNDS_CONTROL_PKG dependencies on GMS_PROJECT_TYPES

Line 101: from gms_project_types gpt,

97: x_sponsored_flag varchar2(1);
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;

Line 2239: gms_project_types gpt,

2235: pobc.reference13 --Vendor id for GMSIP transactions
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

Line 2258: gms_project_types gpt,

2254: decode (apd.prepay_distribution_id ,NULL,line_type_lookup_code,'PREPAY')
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