[Home] [Help]
468: shipment_line_id
469: from rcv_transactions
470: where transaction_id = p_rcv_transaction_id;
471:
472: cursor c_check_receipt_tds_tax(p_shipment_header_id number, p_shipment_line_id number,p_section_type jai_cmn_taxes_all.section_type%type) is--rchandan for bug#4428980
473: select jtc.section_code section_code,
474: jrtl.tax_id tax_id
475: from jai_rcv_line_taxes jrtl,
476: jai_cmn_taxes_all jtc
472: cursor c_check_receipt_tds_tax(p_shipment_header_id number, p_shipment_line_id number,p_section_type jai_cmn_taxes_all.section_type%type) is--rchandan for bug#4428980
473: select jtc.section_code section_code,
474: jrtl.tax_id tax_id
475: from jai_rcv_line_taxes jrtl,
476: jai_cmn_taxes_all jtc
477: where jtc.tax_id = jrtl.tax_id
478: and jrtl.tax_type = jai_constants.tax_type_tds
479: and jtc.section_type = p_section_type--rchandan for bug#4428980
480: and jrtl.shipment_header_id = p_shipment_header_id
551: from po_distributions_all
552: where po_distribution_id = p_po_distribution_id;
553:
554:
555: cursor c_po_taxes(p_po_header_id number, p_po_line_id number, p_line_location_id number,p_section_type jai_cmn_taxes_all.section_type%type)--rchandan for bug#4428980
556: is
557: select jtc.section_code section_code,
558: jpllt.tax_id tax_id
559: from jai_po_taxes jpllt,
556: is
557: select jtc.section_code section_code,
558: jpllt.tax_id tax_id
559: from jai_po_taxes jpllt,
560: jai_cmn_taxes_all jtc
561: where jpllt.tax_id = jtc.tax_id
562: and jpllt.po_header_id = p_po_header_id
563: and jpllt.po_line_id = p_po_line_id
564: and jpllt.line_location_id = p_line_location_id
567: order by jpllt.tax_line_no asc;
568:
569:
570: c_rec_po_distributions_all c_po_distributions_all%rowtype;
571: lv_last_section_type JAI_CMN_TAXES_ALL.section_type%type;
572: c_rec_po_taxes c_po_taxes%rowtype;
573:
574: begin
575:
724: from JAI_AP_TDS_VENDOR_HDRS
725: where vendor_id = p_vendor_id
726: and vendor_site_id = p_vendor_site_id;
727:
728: cursor c_check_section_applicable(p_vendor_id number, p_vendor_site_id number, p_tds_section_code varchar2,p_section_type JAI_CMN_TAXES_ALL.section_type%type) is--rchandan for bug#4428980
729: select 'Y'
730: from JAI_AP_TDS_TH_VSITE_V
731: where vendor_id = p_vendor_id
732: and vendor_site_id = p_vendor_site_id
1089: This is not required as we need to consider all distributions for redefaulting*/
1090: ;
1091:
1092: cursor c_get_threshold
1093: (p_vendor_id number, p_vendor_site_id number, p_tds_section_code varchar2,p_section_type jai_cmn_taxes_all.section_type%type) is--rchandan for bug#4428980
1094: select threshold_hdr_id
1095: from jai_ap_tds_th_vsite_v
1096: where vendor_id = p_vendor_id
1097: and vendor_site_id = p_vendor_site_id
1341: )
1342: is
1343:
1344: cursor c_get_existing_dff_values
1345: (p_invoice_id number, p_invoice_line_number number, p_invoice_distribution_id number, p_section_type jai_cmn_taxes_all.section_type%type) is--rchandan for bug#4428980
1346: select tds_inv_tax_id, default_tax_id, actual_tax_id
1347: from jai_ap_tds_inv_taxes
1348: where invoice_id = p_invoice_id
1349: and nvl(invoice_line_number, -9999) = nvl(p_invoice_line_number, -9999)