38: erl.task_id TASK_ID,
39: erl.distribution_line_number distribution_line_number,
40: apd.invoice_distribution_id invoice_distribution_id,
41: apd.award_id award_set_id
42: from ap_expense_report_lines_all erl,
43: ap_invoice_distributions_all apd,
44: pa_projects_all p,
45: gms_project_types gpt
46: where report_header_id = X_report_header_id
59: erl.task_id TASK_ID,
60: erl.distribution_line_number distribution_line_number,
61: apsat.invoice_distribution_id invoice_distribution_id,
62: apsat.award_id award_set_id
63: from AP_EXPENSE_REPORT_LINES_ALL ERL,
64: AP_SELF_ASSESSED_TAX_DIST_ALL apsat,
65: pa_projects_all p,
66: GMS_PROJECT_TYPES GPT
67: where report_header_id = X_report_header_id