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 2286: gms_project_types gpt,

2282: pobc.reference13 --Vendor id for GMSIP transactions
2283: FROM po_bc_distributions pobc ,
2284: psa_bc_xla_events_gt xlaevt,
2285: pa_expenditure_types et,
2286: gms_project_types gpt,
2287: pa_projects_all pp
2288: WHERE pobc.ae_event_id = xlaevt.event_id
2289: AND pobc.pa_project_id IS NOT NULL
2290: AND pobc.pa_project_id = pp.project_id

Line 2305: gms_project_types gpt,

2301: decode (apd.prepay_distribution_id ,NULL,line_type_lookup_code,'PREPAY')
2302: /* Bug 5645290 - End */
2303: FROM psa_bc_xla_events_gt xlaevt,
2304: ap_invoice_distributions_all apd,
2305: gms_project_types gpt,
2306: pa_projects_all pp,
2307: ap_invoices_all apinv
2308: WHERE apd.bc_event_id = xlaevt.event_id
2309: AND apd.project_id IS NOT NULL

Line 2329: gms_project_types gpt,

2325: SELECT apsat.invoice_distribution_id,
2326: DECODE (apsat.prepay_distribution_id ,NULL,line_type_lookup_code,'PREPAY')
2327: from PSA_BC_XLA_EVENTS_GT XLAEVT,
2328: AP_SELF_ASSESSED_TAX_DIST_ALL apsat,
2329: gms_project_types gpt,
2330: pa_projects_all pp,
2331: ap_invoices_all apinv
2332: WHERE apsat.bc_event_id = xlaevt.event_id
2333: AND apsat.project_id IS NOT NULL