DBA Data[Home] [Help]

APPS.JAI_AP_DTC_GENERATION_PKG dependencies on JAI_AP_TDS_THHOLD_GRPS_S

Line 1884: jai_ap_tds_thhold_grps_s.nextval ,

1880: last_update_login
1881: )
1882: values
1883: (
1884: jai_ap_tds_thhold_grps_s.nextval ,
1885: p_threshold_hdr_id ,
1886: p_vendor_id ,
1887: p_org_tan_num ,
1888: p_vendor_pan_num ,

Line 5140: lv_section_type jai_ap_tds_thhold_grps.section_type%type;

5136: select section_type,section_code
5137: from jai_ap_tds_thhold_grps
5138: where threshold_grp_id = cn_threshold_grp_id;
5139:
5140: lv_section_type jai_ap_tds_thhold_grps.section_type%type;
5141: lv_section_code jai_ap_tds_thhold_grps.section_code%type;
5142:
5143: cursor get_tax_category(cn_threshold_slab_id number)
5144: is

Line 5141: lv_section_code jai_ap_tds_thhold_grps.section_code%type;

5137: from jai_ap_tds_thhold_grps
5138: where threshold_grp_id = cn_threshold_grp_id;
5139:
5140: lv_section_type jai_ap_tds_thhold_grps.section_type%type;
5141: lv_section_code jai_ap_tds_thhold_grps.section_code%type;
5142:
5143: cursor get_tax_category(cn_threshold_slab_id number)
5144: is
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,