APPS.JAI_RGM_THHOLD_PROC_PKG dependencies on JAI_AP_TDS_THHOLD_HDRS

Line 711: lv_customer_type_lkup_code jai_ap_tds_thhold_hdrs.customer_type_lookup_code%type;

707: is
708: ln_reg_id number;
709: ln_org_tan_no JAI_RGM_REGISTRATIONS.attribute_value%type;
710: ln_fin_year jai_rgm_thresholds.fin_year%type;
711: lv_customer_type_lkup_code jai_ap_tds_thhold_hdrs.customer_type_lookup_code%type;
712:
713: /** cursor will fetch org_tan_no from regime setup */
714: cursor c_get_rgm_attribute ( cp_regime_id JAI_RGM_DEFINITIONS.regime_id%type
715: , cp_attribute_type_code JAI_RGM_REGISTRATIONS.attribute_type_code%type

Line 738: , cp_customer_type_lkup_code jai_ap_tds_thhold_hdrs.customer_type_lookup_code%type

734: cursor c_get_threshold_slab ( cp_fin_year jai_rgm_thresholds.fin_year%type
735: , cp_org_tan_no jai_rgm_thresholds.org_tan_no%type
736: , cp_party_type jai_rgm_thresholds.party_type%type
737: , cp_party_id jai_rgm_thresholds.party_id%type
738: , cp_customer_type_lkup_code jai_ap_tds_thhold_hdrs.customer_type_lookup_code%type
739: )
740: is
741: select
742: thslbs.threshold_slab_id

Line 746: ,jai_ap_tds_thhold_hdrs thhdrs

742: thslbs.threshold_slab_id
743: from
744: jai_ap_tds_thhold_slabs thslbs
745: ,jai_ap_tds_thhold_types thtyps
746: ,jai_ap_tds_thhold_hdrs thhdrs
747: ,jai_rgm_thresholds rgmths
748: where
749: thslbs.threshold_type_id = thtyps.threshold_type_id
750: and thtyps.threshold_hdr_id = thhdrs.threshold_hdr_id