APPS.JAI_ETCS_PKG dependencies on JAI_AP_TDS_YEARS

Line 2186: FROM JAI_AP_TDS_YEARS

2182:
2183: -- to get financial and assessment years
2184: CURSOR c_fin_year(p_tan_number IN varchar2, p_fin_year IN NUMBER) IS
2185: SELECT start_date, end_date
2186: FROM JAI_AP_TDS_YEARS
2187: WHERE tan_no = p_tan_number --Date 26/05/2007 by sacsethi for bug 6153881
2188: AND fin_year = p_fin_year;
2189:
2190: -- gives Location_id linked to Organization

Line 2224: v_start_date JAI_AP_TDS_YEARS.start_date%type ;

2220: ln_batch_id number ;
2221: lv_etcs_yearly_returns varchar2(1) ;
2222: v_conc_request_id NUMBER(15) ;
2223: v_deductor_pan VARCHAR2(200);
2224: v_start_date JAI_AP_TDS_YEARS.start_date%type ;
2225: v_end_date JAI_AP_TDS_YEARS.end_date%type;
2226:
2227: -- File Header variables
2228: v_line_number NUMBER(9);

Line 2225: v_end_date JAI_AP_TDS_YEARS.end_date%type;

2221: lv_etcs_yearly_returns varchar2(1) ;
2222: v_conc_request_id NUMBER(15) ;
2223: v_deductor_pan VARCHAR2(200);
2224: v_start_date JAI_AP_TDS_YEARS.start_date%type ;
2225: v_end_date JAI_AP_TDS_YEARS.end_date%type;
2226:
2227: -- File Header variables
2228: v_line_number NUMBER(9);
2229: v_record_type CHAR(2);