APPS.JAI_AP_TDS_GENERATION_PKG dependencies on JAI_AP_TDS_THHOLD_TYPES

Line 446: from jai_ap_tds_thhold_types

442: from jai_ap_tds_thhold_slabs
443: where threshold_hdr_id = p_threshold_hdr_id
444: and threshold_type_id in
445: ( select threshold_type_id
446: from jai_ap_tds_thhold_types
447: where threshold_hdr_id = p_threshold_hdr_id
448: and threshold_type = p_threshold_type
449: /* Bug 4522540. Added by Lakshmi Gopalsami
450: Added the following date condition */

Line 461: from jai_ap_tds_thhold_types

457:
458: /*following cursor added for FP bug 6345725 - need to check if there are any active slab(s) defined */
459: cursor c_check_slabs_end_dated (p_threshold_hdr_id number) is
460: select 1
461: from jai_ap_tds_thhold_types
462: where threshold_hdr_id = p_threshold_hdr_id
463: and trunc(p_accounting_Date) between from_date and nvl(to_date, p_accounting_date + 1);
464:
465: ln_check_slab_exists NUMBER;

Line 3353: FROM jai_ap_tds_thhold_types

3349: FROM jai_ap_tds_thhold_slabs
3350: WHERE threshold_hdr_id = p_threshold_hdr_id
3351: AND threshold_type_id in
3352: ( SELECT threshold_type_id
3353: FROM jai_ap_tds_thhold_types
3354: WHERE threshold_hdr_id = p_threshold_hdr_id
3355: AND threshold_type = p_threshold_type
3356: AND trunc(sysdate) between from_date and nvl(to_date, sysdate + 1)
3357: )

Line 3365: lv_threshold_type jai_ap_tds_thhold_types.threshold_type%TYPE;

3361:
3362: r_get_threshold_grp_dtl c_get_threshold_grp_dtl%ROWTYPE;
3363: ln_effective_invoice_amt NUMBER;
3364: r_jai_ap_tds_thhold_slabs c_jai_ap_tds_thhold_slabs%ROWTYPE;
3365: lv_threshold_type jai_ap_tds_thhold_types.threshold_type%TYPE;
3366:
3367: BEGIN
3368: IF p_threshold_grp_id IS NULL THEN
3369: OPEN c_get_threshold_grp_id(p_prepay_distribution_id);