APPS.JAI_AP_DTC_GENERATION_PKG dependencies on JAI_AP_TDS_THHOLD_HDRS

Line 2902: from jai_ap_tds_thhold_hdrs

2898:
2899: cursor c_get_exception_setup(cn_hdr_id number)
2900: is
2901: select nvl(exception_setup_flag,'N')
2902: from jai_ap_tds_thhold_hdrs
2903: where threshold_hdr_id = ln_threshold_hdr_id;
2904:
2905:
2906: cursor c_get_multiple_rate_setup(cn_hdr_id number)

Line 2909: from jai_ap_tds_thhold_hdrs

2905:
2906: cursor c_get_multiple_rate_setup(cn_hdr_id number)
2907: is
2908: select nvl(multiple_rate_setup,'N')
2909: from jai_ap_tds_thhold_hdrs
2910: where threshold_hdr_id = ln_threshold_hdr_id;
2911:
2912: lv_multiple_rate_setup jai_ap_tds_thhold_hdrs.multiple_rate_setup%type;
2913:

Line 2912: lv_multiple_rate_setup jai_ap_tds_thhold_hdrs.multiple_rate_setup%type;

2908: select nvl(multiple_rate_setup,'N')
2909: from jai_ap_tds_thhold_hdrs
2910: where threshold_hdr_id = ln_threshold_hdr_id;
2911:
2912: lv_multiple_rate_setup jai_ap_tds_thhold_hdrs.multiple_rate_setup%type;
2913:
2914: cursor c_jai_ap_tds_thhold_slabs_new(
2915: p_threshold_hdr_id number,
2916: p_threshold_type varchar2,

Line 5149: FROM JAI_AP_TDS_THHOLD_HDRS JATTH,

5145: SELECT --JATTTY.THRESHOLD_TYPE_ID, JATTTY.FROM_DATE, JATTTY.TO_DATE, JATTTY.THRESHOLD_TYPE, JATTTA.THRESHOLD_SLAB_ID, JATTS.FROM_AMOUNT, JATTS.TO_AMOUNT,
5146: JATTTA.TAX_CATEGORY_ID
5147: --, JATTTA.OPERATING_UNIT_ID
5148: ,jatth.threshold_hdr_id --Added by Chong for bug#16414088 20130313
5149: FROM JAI_AP_TDS_THHOLD_HDRS JATTH,
5150: JAI_AP_TDS_THHOLD_TYPES JATTTY,
5151: JAI_AP_TDS_THHOLD_SLABS JATTS,
5152: JAI_AP_TDS_THHOLD_TAXES JATTTA
5153: WHERE JATTS.THRESHOLD_SLAB_ID = p_threshold_slab_id

Line 9072: FROM jai_ap_tds_thhold_hdrs

9068:
9069: /*Get multiple_rate_flg by Hdr_id*/
9070: CURSOR c_multiple_rate_setup(p_threshold_hdr_id NUMBER) IS
9071: SELECT NVL(multiple_rate_setup, 'N')
9072: FROM jai_ap_tds_thhold_hdrs
9073: WHERE threshold_hdr_id = p_threshold_hdr_id;
9074:
9075: /*Get slab by natrual account and threshold_hdr_id*/
9076: CURSOR c_get_tds_thhold_slabs_byNt(p_threshold_hdr_id NUMBER,

Line 9133: lv_multiple_rate_setup jai_ap_tds_thhold_hdrs.multiple_rate_setup%TYPE;

9129: ln_effective_invoice_amt NUMBER;
9130: r_jai_ap_tds_thhold_slabs c_jai_ap_tds_thhold_slabs%ROWTYPE;
9131: r_get_tds_thhold_slabs_byNt c_get_tds_thhold_slabs_byNt%ROWTYPE;
9132: lv_threshold_type jai_ap_tds_thhold_types.threshold_type%TYPE;
9133: lv_multiple_rate_setup jai_ap_tds_thhold_hdrs.multiple_rate_setup%TYPE;
9134: lv_invoice_distribution_id jai_ap_tds_inv_taxes.invoice_distribution_id%TYPE;
9135: lv_set_of_book_id NUMBER;
9136: lv_legal_entity_id NUMBER;
9137: lv_natural_account_segment VARCHAR2(100);