APPS.JAI_AP_TDS_GENERATION_PKG dependencies on JAI_AP_TDS_THHOLD_TYPES

Line 904: from jai_ap_tds_thhold_types

900: from jai_ap_tds_thhold_slabs
901: where threshold_hdr_id = p_threshold_hdr_id
902: and threshold_type_id in
903: ( select threshold_type_id
904: from jai_ap_tds_thhold_types
905: where threshold_hdr_id = p_threshold_hdr_id
906: and threshold_type = p_threshold_type
907: /* Bug 4522540. Added by Lakshmi Gopalsami
908: Added the following date condition */

Line 919: from jai_ap_tds_thhold_types

915:
916: /*following cursor added for FP bug 6345725 - need to check if there are any active slab(s) defined */
917: cursor c_check_slabs_end_dated (p_threshold_hdr_id number) is
918: select 1
919: from jai_ap_tds_thhold_types
920: where threshold_hdr_id = p_threshold_hdr_id
921: and trunc(p_accounting_Date) between from_date and nvl(to_date, p_accounting_date + 1);
922:
923: ln_check_slab_exists NUMBER;

Line 4598: FROM jai_ap_tds_thhold_types

4594: FROM jai_ap_tds_thhold_slabs
4595: WHERE threshold_hdr_id = p_threshold_hdr_id
4596: AND threshold_type_id in
4597: ( SELECT threshold_type_id
4598: FROM jai_ap_tds_thhold_types
4599: WHERE threshold_hdr_id = p_threshold_hdr_id
4600: AND threshold_type = p_threshold_type
4601: AND trunc(sysdate) between from_date and nvl(to_date, sysdate + 1)
4602: )

Line 4610: lv_threshold_type jai_ap_tds_thhold_types.threshold_type%TYPE;

4606:
4607: r_get_threshold_grp_dtl c_get_threshold_grp_dtl%ROWTYPE;
4608: ln_effective_invoice_amt NUMBER;
4609: r_jai_ap_tds_thhold_slabs c_jai_ap_tds_thhold_slabs%ROWTYPE;
4610: lv_threshold_type jai_ap_tds_thhold_types.threshold_type%TYPE;
4611:
4612: BEGIN
4613: IF p_threshold_grp_id IS NULL THEN
4614: OPEN c_get_threshold_grp_id(p_prepay_distribution_id);