APPS.JAI_RGM_THHOLD_PROC_PKG dependencies on JAI_AP_TDS_THHOLD_HDRS

Line 800: lv_customer_type_lkup_code jai_ap_tds_thhold_hdrs.customer_type_lookup_code%type;

796: is
797: ln_reg_id number;
798: ln_org_tan_no JAI_RGM_REGISTRATIONS.attribute_value%type;
799: ln_fin_year jai_rgm_thresholds.fin_year%type;
800: lv_customer_type_lkup_code jai_ap_tds_thhold_hdrs.customer_type_lookup_code%type;
801:
802: /** cursor will fetch org_tan_no from regime setup */
803: cursor c_get_rgm_attribute ( cp_regime_id JAI_RGM_DEFINITIONS.regime_id%type
804: , cp_attribute_type_code JAI_RGM_REGISTRATIONS.attribute_type_code%type

Line 827: , cp_customer_type_lkup_code jai_ap_tds_thhold_hdrs.customer_type_lookup_code%type

823: cursor c_get_threshold_slab ( cp_fin_year jai_rgm_thresholds.fin_year%type
824: , cp_org_tan_no jai_rgm_thresholds.org_tan_no%type
825: , cp_party_type jai_rgm_thresholds.party_type%type
826: , cp_party_id jai_rgm_thresholds.party_id%type
827: , cp_customer_type_lkup_code jai_ap_tds_thhold_hdrs.customer_type_lookup_code%type
828: )
829: is
830: select
831: thslbs.threshold_slab_id

Line 835: ,jai_ap_tds_thhold_hdrs thhdrs

831: thslbs.threshold_slab_id
832: from
833: jai_ap_tds_thhold_slabs thslbs
834: ,jai_ap_tds_thhold_types thtyps
835: ,jai_ap_tds_thhold_hdrs thhdrs
836: ,jai_rgm_thresholds rgmths
837: where
838: thslbs.threshold_type_id = thtyps.threshold_type_id
839: and thtyps.threshold_hdr_id = thhdrs.threshold_hdr_id