[Home] [Help]
175: A.last_updated_by LAST_UPDATED_BY,
176: A.created_by CREATED_BY,
177: NVL(A.last_update_login,0) LAST_UPDATE_LOGIN,
178: inv.invoice_num invoice_num
179: FROM ap_self_assessed_tax_dist_all A,
180: PA_PROJECTS_ALL P,
181: gms_project_types gpt,
182: AP_INVOICES_ALL INV
183: WHERE a.invoice_id = p_invoice_id
209: and adl.adl_line_num = 1
210: and adl.adl_status = 'A' )
211: union /* BUG 14216205 : Added the union for SAT */
212: select 1
213: FROM AP_SELF_ASSESSED_TAX_DIST_ALL b,
214: PA_PROJECTS_ALL P,
215: GMS_PROJECT_TYPES_ALL GPT
216: WHERE b.invoice_id = p_invoice_id
217: AND b.project_id = p.project_id
263: A.last_updated_by LAST_UPDATED_BY,
264: a.CREATED_BY CREATED_BY,
265: NVL(a.LAST_UPDATE_LOGIN,0) LAST_UPDATE_LOGIN,
266: gms_awards_dist_pkg.get_award_set_id NEW_AWARD_SET_ID
267: FROM ap_self_assessed_tax_dist_all A,
268: GMS_AWARD_DISTRIBUTIONS ADL
269: WHERE a.invoice_id = p_invoice_id
270: AND ADL.AWARD_SET_ID = a.AWARD_ID
271: AND line_type_lookup_code='NONREC_TAX'
287: and ADL2.ADL_STATUS = 'I'
288: union
289: select adl2.award_set_id
290: from gms_award_distributions adl2,
291: AP_SELF_ASSESSED_TAX_DIST_ALL APSAT
292: where apsat.invoice_id = p_invoice_id
293: and APSAT.AWARD_ID is not null
294: and line_type_lookup_code='NONREC_TAX'
295: and adl2.award_set_id = apsat.award_id
314: and adl2.adl_status = 'A'
315: UNION
316: select ADL2.AWARD_SET_ID
317: from GMS_AWARD_DISTRIBUTIONS ADL2,
318: AP_SELF_ASSESSED_TAX_DIST_ALL APSAT
319: where apsat.invoice_id = p_invoice_id
320: and APSAT.AWARD_ID is not null
321: and adl2.award_set_id <> apsat.award_id
322: and adl2.invoice_id = apsat.invoice_id
337: and P.PROJECT_TYPE = GPT.PROJECT_TYPE
338: and gpt.sponsored_flag = 'N'
339: union
340: select b.INVOICE_DISTRIBUTION_ID
341: from AP_SELF_ASSESSED_TAX_DIST_ALL B,
342: pa_projects_all p,
343: gms_project_types gpt
344: where b.invoice_id = p_invoice_id
345: and b.project_id = p.project_id
560: where apd.invoice_id = p_invoice_id
561: and apd.invoice_distribution_id = l_dummy_tab(i) ;
562: /* BUG 14216205 : Added the following Code for SAT : Starts */
563: FORALL j in l_dummy_tab.FIRST..l_dummy_tab.LAST
564: UPDATE AP_SELF_ASSESSED_TAX_DIST_ALL apsat
565: set AWARD_ID = null
566: where APSAT.INVOICE_ID = P_INVOICE_ID
567: and apsat.invoice_distribution_id = l_dummy_tab(j) ;
568: /* BUG 14216205 : Added the following Code for SAT : Ends */
636: and award_set_id not in ( select award_id from ap_invoice_distributions_all
637: where invoice_id = p_invoice_id
638: and award_id is not NULL
639: union /* BUG 14216205 : Added the union for SAT */
640: select award_id from AP_SELF_ASSESSED_TAX_DIST_ALL
641: where INVOICE_ID = P_INVOICE_ID
642: and AWARD_ID is not null) ;
643:
644: return ;
717: and distribution_line_number = l_distribution_line_number(k)
718: and invoice_distribution_id = l_invoice_distribution_id(k) ;
719: /* BUG 14216205 : Added the following Code for SAT : Starts */
720: FORALL J in l_invoice_distribution_id.FIRST..l_invoice_distribution_id.LAST
721: update AP_SELF_ASSESSED_TAX_DIST_ALL
722: set AWARD_ID = L_NEW_AWARD_SET_ID(J)
723: where INVOICE_ID = L_INVOICE_ID(J)
724: and DISTRIBUTION_LINE_NUMBER = L_DISTRIBUTION_LINE_NUMBER(J)
725: and INVOICE_DISTRIBUTION_ID = L_INVOICE_DISTRIBUTION_ID(J) ;
735: and award_set_id not in ( select award_id from ap_invoice_distributions_all
736: where invoice_id = p_invoice_id
737: and award_id is not NULL
738: union /* BUG 14216205 : Added the union for SAT */
739: select award_id from ap_self_assessed_tax_dist_all
740: where INVOICE_ID = P_INVOICE_ID
741: and AWARD_ID is not null) ;
742:
743: -- Bug 3077074