APPS.JAI_AP_TDS_OLD_PKG dependencies on JAI_CMN_TAXES_ALL

Line 107: FROM JAI_CMN_TAXES_ALL

103: WHERE invoice_id = inv_id;
104:
105: CURSOR vendor(t_id NUMBER) IS
106: SELECT vendor_id
107: FROM JAI_CMN_TAXES_ALL
108: WHERE tax_id = t_id;
109:
110:
111: CURSOR for_payment_status(inv_num VARCHAR2,vend_id NUMBER,organization NUMBER) IS ----for information about tds invoice

Line 1021: FROM JAI_CMN_TAXES_ALL

1017: AND source_attribute = p_attribute;*/
1018:
1019: CURSOR for_vendor_id(t_id NUMBER) IS
1020: SELECT vendor_id
1021: FROM JAI_CMN_TAXES_ALL
1022: WHERE tax_id = t_id;
1023:
1024: CURSOR for_payment_status(inv_num VARCHAR2,vend_id NUMBER,organization NUMBER) IS
1025: ----for information about tds invoice

Line 1890: FROM JAI_CMN_TAXES_ALL

1886: WHERE invoice_distribution_id=prepay_dist_id);
1887:
1888: CURSOR for_vendor_id(t_id NUMBER) IS
1889: SELECT vendor_id
1890: FROM JAI_CMN_TAXES_ALL
1891: WHERE tax_id = t_id;
1892:
1893: CURSOR for_payment_status(inv_num VARCHAR2,vend_id NUMBER,organization NUMBER) IS --for information about tds invoice
1894: SELECT payment_status_flag,

Line 2146: from JAI_CMN_TAXES_ALL

2142:
2143:
2144: cursor c_get_tax_rate(p_tax_id number) is
2145: select tax_rate
2146: from JAI_CMN_TAXES_ALL
2147: where tax_id = p_tax_id;
2148:
2149: v_tax_id JAI_CMN_TAXES_ALL.tax_id%type;
2150: v_tax_rate JAI_CMN_TAXES_ALL.tax_rate%type;

Line 2149: v_tax_id JAI_CMN_TAXES_ALL.tax_id%type;

2145: select tax_rate
2146: from JAI_CMN_TAXES_ALL
2147: where tax_id = p_tax_id;
2148:
2149: v_tax_id JAI_CMN_TAXES_ALL.tax_id%type;
2150: v_tax_rate JAI_CMN_TAXES_ALL.tax_rate%type;
2151:
2152: v_distribution_cnt number;
2153: v_loop_index number;

Line 2150: v_tax_rate JAI_CMN_TAXES_ALL.tax_rate%type;

2146: from JAI_CMN_TAXES_ALL
2147: where tax_id = p_tax_id;
2148:
2149: v_tax_id JAI_CMN_TAXES_ALL.tax_id%type;
2150: v_tax_rate JAI_CMN_TAXES_ALL.tax_rate%type;
2151:
2152: v_distribution_cnt number;
2153: v_loop_index number;
2154: v_prepayment_amount number;

Line 3615: FROM JAI_CMN_TAXES_ALL

3611: WHERE Invoice_Id = p_invoice_id;
3612:
3613: CURSOR Fetch_Tds_Vendor_Dtls_Cur( v_tds_tax_id IN NUMBER ) IS
3614: SELECT Vendor_Id, Vendor_Site_Id
3615: FROM JAI_CMN_TAXES_ALL
3616: WHERE Tax_Id = v_tds_tax_id;
3617:
3618: CURSOR Fetch_Inv_Id_Cur( v_inv_num IN VARCHAR2, v_vendor_id IN NUMBER, v_vendor_site_id IN NUMBER ) IS
3619: SELECT Invoice_Id