[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
307: A.created_by CREATED_BY,
308: A.last_update_login LAST_UPDATE_LOGIN
309: from ap_invoice_distributions_all A,
310: pa_projects_all B,
311: gms_project_types C
312: where invoice_id = p_invoice_id
313: and distribution_line_number = p_distribution_line_number
314: and invoice_distribution_id = p_invoice_distribution_id
315: and a.project_id = b.project_id
758: NVL(A.last_update_login,0) LAST_UPDATE_LOGIN,
759: inv.invoice_num invoice_num
760: from ap_invoice_distributions_all A,
761: pa_projects_all p,
762: gms_project_types gpt,
763: ap_invoices_all inv
764: where a.invoice_id = p_invoice_id
765: and a.project_id = p.project_id
766: and p.project_type = gpt.project_type
775: cursor c2 is
776: SELECT 1
777: from ap_invoice_distributions_all A,
778: pa_projects_all p,
779: gms_project_types gpt
780: where a.invoice_id = p_invoice_id
781: and a.project_id = p.project_id
782: and p.project_type = gpt.project_type
783: and gpt.sponsored_flag = 'Y'
899: -- and apd.award_id is not NULL
900: -- and apd.invoice_distribution_id in ( select a.invoice_distribution_id
901: -- from ap_invoice_distributions_all A,
902: -- pa_projects_all p,
903: -- gms_project_types gpt
904: -- where a.invoice_id = p_invoice_id
905: -- and a.project_id = p.project_id
906: -- and p.project_type = gpt.project_type
907: -- and gpt.sponsored_flag = 'N' ) ;
912: select a.invoice_distribution_id
913: bulk collect into l_dummy_tab
914: from ap_invoice_distributions_all A,
915: pa_projects_all p,
916: gms_project_types gpt
917: where a.invoice_id = p_invoice_id
918: and a.project_id = p.project_id
919: and a.award_id is not NULL
920: and p.project_type = gpt.project_type