[Home] [Help]
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;
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
2291: AND pp.project_type = gpt.project_type
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
2310: AND apinv.invoice_id = apd.invoice_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
2334: AND apinv.invoice_id = apsat.invoice_id
4496: SELECT start_date,
4497: completion_date
4498: INTO project_start_date,
4499: project_end_date
4500: FROM pa_projects_all
4501: WHERE project_id = x_project_id;
4502:
4503: -- Added for GMS enhancements : Bug : 5583170
4504: -- If time pjhase code is date range then