APPS.JAI_AP_TDS_TAX_DEFAULTATION dependencies on JAI_AP_TDS_VENDOR_HDRS

Line 691: from JAI_AP_TDS_VENDOR_HDRS

687: cursor c_ja_in_vendor_tds_info_hdr (p_vendor_id number, p_vendor_site_id number)
688: is
689: select section_code,
690: tax_id
691: from JAI_AP_TDS_VENDOR_HDRS
692: where vendor_id = p_vendor_id
693: and vendor_site_id = p_vendor_site_id;
694:
695: crec_ja_in_vendor_tds_info_hdr c_ja_in_vendor_tds_info_hdr%rowtype;

Line 777: from JAI_AP_TDS_VENDOR_HDRS

773: is
774:
775: cursor c_ja_in_vendor_tds_info_hdr(p_vendor_id number, p_vendor_site_id number) is
776: select nvl(confirm_pan_flag, 'N') confirm_pan_flag
777: from JAI_AP_TDS_VENDOR_HDRS
778: where vendor_id = p_vendor_id
779: and vendor_site_id = p_vendor_site_id;
780:
781: 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 789: lv_confirm_pan_flag JAI_AP_TDS_VENDOR_HDRS.confirm_pan_flag%type;

785: and vendor_site_id = p_vendor_site_id
786: and section_type = p_section_type--rchandan for bug#4428980
787: and section_code = p_tds_section_code;
788:
789: lv_confirm_pan_flag JAI_AP_TDS_VENDOR_HDRS.confirm_pan_flag%type;
790: lv_check_section_applicable varchar2(1);
791:
792: begin
793:

Line 1450: jai_ap_tds_vendor_hdrs c,

1446: select c.pan_no pan_no,
1447: d.org_tan_num tan_no
1448: from po_vendors a,
1449: po_vendor_sites_all b,
1450: jai_ap_tds_vendor_hdrs c,
1451: jai_ap_tds_org_tan_v d --- JAI_AP_TDS_ORG_TANS is changed to view jai_ap_tds_org_tan_v 4323338
1452: where a.vendor_id = b.vendor_id
1453: and b.vendor_id = c.vendor_id
1454: and b.vendor_site_id = c.vendor_site_id

Line 1481: lv_pan_no jai_ap_tds_vendor_hdrs.pan_no%type;

1477: r_get_threshold c_get_threshold%rowtype;
1478: r_jai_ap_tds_thhold_slabs c_jai_ap_tds_thhold_slabs%rowtype;
1479: r_jai_ap_tds_thhold_taxes c_jai_ap_tds_thhold_taxes%rowtype;
1480:
1481: lv_pan_no jai_ap_tds_vendor_hdrs.pan_no%type;
1482: 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
1483:
1484:
1485: ln_total_invoice_amount number;