DBA Data[Home] [Help]

APPS.GMS_OIE_INT_PKG dependencies on GMS_PROJECT_TYPES

Line 108: gms_project_types pt

104:
105: select nvl(pt.sponsored_flag, 'N')
106: into p_sponsored_flag
107: from pa_projects_all b,
108: gms_project_types pt
109: where b.segment1 = p_project_num
110: and b.project_type = pt.project_type
111: and pt.sponsored_flag = 'Y';
112:

Line 334: gms_project_types gpt,

330: null -- bud_task_id
331: from ap_invoice_distributions_all aid,
332: ap_expense_report_headers_all aerh,
333: ap_expense_report_lines_all aerl,
334: gms_project_types gpt,
335: pa_projects_all pp
336: where aerh.vouchno = aid.invoice_id
337: and aerh.report_header_id = aerl.report_header_id
338: and aid.invoice_id = v_invoice_id

Line 369: pa_projects_all pp, gms_project_types gpt

365: select aeh.report_header_id, aerl.project_id bulk collect
366: into cur_report_header_id, cur_project_id
367: from ap_expense_report_headers_all aeh,
368: ap_expense_report_lines_all aerl,
369: pa_projects_all pp, gms_project_types gpt
370: where aeh.report_header_id = aerl.report_header_id
371: and aeh.vouchno = p_invoice_id(i)
372: and aerl.project_id = pp.project_id
373: and pp.project_type = gpt.project_type