DBA Data[Home] [Help]

APPS.JAI_EXCISE_SCRIPTS_PKG dependencies on JAI_CMN_FIN_YEARS

Line 880: FROM JAI_CMN_FIN_YEARS

876: ORDER BY slno;
877:
878: CURSOR cur_get_curr_fin_year IS
879: SELECT fin_year
880: FROM JAI_CMN_FIN_YEARS
881: WHERE organization_id = p_organization_id
882: AND fin_active_flag = 'Y';
883:
884: CURSOR cur_get_fin_year IS

Line 886: FROM JAI_CMN_FIN_YEARS

882: AND fin_active_flag = 'Y';
883:
884: CURSOR cur_get_fin_year IS
885: SELECT fin_year
886: FROM JAI_CMN_FIN_YEARS
887: WHERE organization_id = p_organization_id
888: AND p_date between fin_year_start_date and fin_year_end_date;
889:
890: CURSOR cur_get_rg_slno(cp_fin_year NUMBER,cp_tax_type VARCHAR2,cp_date DATE) IS

Line 2372: FROM JAI_CMN_FIN_YEARS

2368:
2369: CURSOR cur_get_fin_year( cp_organization_id NUMBER,
2370: cp_date DATE ) IS
2371: SELECT fin_year
2372: FROM JAI_CMN_FIN_YEARS
2373: WHERE organization_id = cp_organization_id
2374: AND cp_date between fin_year_start_date and fin_year_end_date;
2375:
2376: CURSOR cur_get_rg23_cess_slno( cp_organization_id NUMBER,