[Home] [Help]
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
47: and erl.distribution_line_number= apd.distribution_line_number
48: and apd.invoice_id = X_invoice_id
49: and erl.project_id = apd.project_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
68: and ERL.DISTRIBUTION_LINE_NUMBER= APSAT.DISTRIBUTION_LINE_NUMBER
69: and apsat.invoice_id = X_invoice_id
70: and ERL.PROJECT_ID = APSAT.PROJECT_ID
335: A.created_by CREATED_BY,
336: A.last_update_login LAST_UPDATE_LOGIN
337: from ap_invoice_distributions_all A,
338: pa_projects_all B,
339: gms_project_types C
340: where invoice_id = p_invoice_id
341: and distribution_line_number = p_distribution_line_number
342: and invoice_distribution_id = p_invoice_distribution_id
343: and a.project_id = b.project_id
355: A.created_by CREATED_BY,
356: A.last_update_login LAST_UPDATE_LOGIN
357: from AP_SELF_ASSESSED_TAX_DIST_ALL A,
358: pa_projects_all B,
359: gms_project_types C
360: where invoice_id = p_invoice_id
361: and distribution_line_number = p_distribution_line_number
362: and invoice_distribution_id = p_invoice_distribution_id
363: and a.PROJECT_ID = B.PROJECT_ID
829: NVL(A.last_update_login,0) LAST_UPDATE_LOGIN,
830: inv.invoice_num invoice_num
831: from ap_invoice_distributions_all A,
832: pa_projects_all p,
833: gms_project_types gpt,
834: ap_invoices_all inv
835: where a.invoice_id = p_invoice_id
836: and a.project_id = p.project_id
837: and p.project_type = gpt.project_type
846: cursor c2 is
847: SELECT 1
848: from ap_invoice_distributions_all A,
849: pa_projects_all p,
850: gms_project_types gpt
851: where a.invoice_id = p_invoice_id
852: and a.project_id = p.project_id
853: and p.project_type = gpt.project_type
854: and gpt.sponsored_flag = 'Y'
970: -- and apd.award_id is not NULL
971: -- and apd.invoice_distribution_id in ( select a.invoice_distribution_id
972: -- from ap_invoice_distributions_all A,
973: -- pa_projects_all p,
974: -- gms_project_types gpt
975: -- where a.invoice_id = p_invoice_id
976: -- and a.project_id = p.project_id
977: -- and p.project_type = gpt.project_type
978: -- and gpt.sponsored_flag = 'N' ) ;
983: select a.invoice_distribution_id
984: bulk collect into l_dummy_tab
985: from ap_invoice_distributions_all A,
986: pa_projects_all p,
987: gms_project_types gpt
988: where a.invoice_id = p_invoice_id
989: and a.project_id = p.project_id
990: and a.award_id is not NULL
991: and p.project_type = gpt.project_type