APPS.JAI_AP_TDS_TAX_DEFAULTATION dependencies on JAI_AP_TDS_VENDOR_HDRS

Line 638: from JAI_AP_TDS_VENDOR_HDRS

634: cursor c_ja_in_vendor_tds_info_hdr (p_vendor_id number, p_vendor_site_id number)
635: is
636: select section_code,
637: tax_id
638: from JAI_AP_TDS_VENDOR_HDRS
639: where vendor_id = p_vendor_id
640: and vendor_site_id = p_vendor_site_id;
641:
642: crec_ja_in_vendor_tds_info_hdr c_ja_in_vendor_tds_info_hdr%rowtype;

Line 724: from JAI_AP_TDS_VENDOR_HDRS

720: is
721:
722: cursor c_ja_in_vendor_tds_info_hdr(p_vendor_id number, p_vendor_site_id number) is
723: select nvl(confirm_pan_flag, 'N') confirm_pan_flag
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

Line 736: lv_confirm_pan_flag JAI_AP_TDS_VENDOR_HDRS.confirm_pan_flag%type;

732: and vendor_site_id = p_vendor_site_id
733: and section_type = p_section_type--rchandan for bug#4428980
734: and section_code = p_tds_section_code;
735:
736: lv_confirm_pan_flag JAI_AP_TDS_VENDOR_HDRS.confirm_pan_flag%type;
737: lv_check_section_applicable varchar2(1);
738:
739: begin
740:

Line 1162: jai_ap_tds_vendor_hdrs c,

1158: select c.pan_no pan_no,
1159: d.org_tan_num tan_no
1160: from po_vendors a,
1161: po_vendor_sites_all b,
1162: jai_ap_tds_vendor_hdrs c,
1163: jai_ap_tds_org_tan_v d --- JAI_AP_TDS_ORG_TANS is changed to view jai_ap_tds_org_tan_v 4323338
1164: where a.vendor_id = b.vendor_id
1165: and b.vendor_id = c.vendor_id
1166: and b.vendor_site_id = c.vendor_site_id

Line 1186: lv_pan_no jai_ap_tds_vendor_hdrs.pan_no%type;

1182: r_get_threshold c_get_threshold%rowtype;
1183: r_jai_ap_tds_thhold_slabs c_jai_ap_tds_thhold_slabs%rowtype;
1184: r_jai_ap_tds_thhold_taxes c_jai_ap_tds_thhold_taxes%rowtype;
1185:
1186: lv_pan_no jai_ap_tds_vendor_hdrs.pan_no%type;
1187: lv_tan_no jai_ap_tds_org_tan_v.org_tan_num %type;--- JAI_AP_TDS_ORG_TANS is changed to view jai_ap_tds_org_tan_v 4323338
1188:
1189:
1190: ln_total_invoice_amount number;