[Home] [Help]
198: ap_expense_report_lines XL,
199: ap_lookup_codes LC,
200: PA_PROJECTS_ALL PAP, -- AP_WEB_PA_PROJECTS_V PAP, -- bug 1652647
201: PA_TASKS PAT, -- AP_WEB_PA_PROJECTS_TASKS_V PAT, -- bug 1652647
202: GMS_AWARDS GMS,
203: AP_POL_VIOLATIONS_V AV
204: WHERE XL.report_header_id = p_report_header_id
205: AND XL.project_id is not null
206: AND XL.task_id is not null
303: ap_credit_card_trxns CC,
304: ap_lookup_codes LC,
305: PA_PROJECTS_ALL PAP, -- AP_WEB_PA_PROJECTS_V PAP, -- bug 1652647
306: PA_TASKS PAT, -- AP_WEB_PA_PROJECTS_TASKS_V PAT -- bug 1652647
307: GMS_AWARDS GMS,
308: AP_POL_VIOLATIONS_V AV
309: WHERE XL.report_header_id = p_report_header_id
310: AND XL.report_header_id = XH.report_header_id
311: AND XL.project_id is not null
394: ap_expense_report_headers XH,
395: ap_lookup_codes LC,
396: PA_PROJECTS_ALL PAP, -- AP_WEB_PA_PROJECTS_V PAP, -- bug 1652647
397: PA_TASKS PAT, -- AP_WEB_PA_PROJECTS_TASKS_V PAT -- bug 1652647
398: GMS_AWARDS GMS,
399: AP_POL_VIOLATIONS_V AV
400: WHERE XL.report_header_id = p_report_header_id
401: AND XL.report_header_id = XH.report_header_id
402: AND XL.project_id is not null
2670: ap_expense_report_lines XL,
2671: ap_lookup_codes LC,
2672: PA_PROJECTS_ALL PAP,
2673: PA_TASKS PAT,
2674: GMS_AWARDS GMS
2675: WHERE XL.report_header_id = p_report_header_id
2676: AND XL.project_id is not null
2677: AND XL.task_id is not null
2678: AND XL.web_parameter_id = XP.parameter_id