APPS.JAI_AP_TDS_GENERATION_PKG dependencies on JAI_AP_TDS_YEARS

Line 983: from JAI_AP_TDS_YEARS

979: lv_regn_type_others VARCHAR2(25);
980:
981: cursor c_get_fin_year(p_accounting_date date, p_org_id number) is
982: select fin_year
983: from JAI_AP_TDS_YEARS
984: where tan_no in /* where clause and subquery added by ssumaith - bug# 4448789*/
985: (
986: SELECT attribute_value
987: FROM JAI_RGM_ORG_REGNS_V

Line 1128: ln_fin_year JAI_AP_TDS_YEARS.fin_year%type;

1124: lv_pan_no JAI_AP_TDS_VENDOR_HDRS.pan_no%type;
1125: lv_tan_no jai_ap_tds_org_tan_v.org_tan_num %type; --rchandan for bug#4323338
1126: lv_confirm_pan_flag JAI_AP_TDS_VENDOR_HDRS.confirm_pan_flag%type; /*Bug 11896260*/
1127: ln_exchange_rate number;
1128: ln_fin_year JAI_AP_TDS_YEARS.fin_year%type;
1129: lv_slab_transition_tds_event jai_ap_tds_thhold_trxs.tds_event%type;
1130:
1131: ln_no_of_tds_inv_generated number := 0;
1132: lb_result boolean;

Line 4313: FROM jai_ap_tds_years

4309:
4310: /*START, Added by Bgowrava for Bug#9214036*/
4311: CURSOR c_get_rnd_factor (p_org_id IN NUMBER, p_inv_date in date ) IS
4312: SELECT nvl(tds_rounding_factor,0), tds_rounding_start_date
4313: FROM jai_ap_tds_years
4314: WHERE legal_entity_id = p_org_id
4315: AND trunc (p_inv_date) between start_date and end_date ;
4316: /*END, Added by Bgowrava for Bug#9214036*/
4317: