DBA Data[Home] [Help]

APPS.JAI_RGM_THHOLD_PROC_PKG dependencies on JAI_RGM_REGISTRATIONS

Line 695: , p_org_tan_no in JAI_RGM_REGISTRATIONS.attribute_value%type default null

691: /*------------------------------------------------------------------------------------------------------------*/
692: procedure get_threshold_slab_id
693: (
694: p_regime_id in jai_rgm_thresholds.regime_id%type
695: , p_org_tan_no in JAI_RGM_REGISTRATIONS.attribute_value%type default null
696: , p_organization_id in hr_organization_units.organization_id%type default null
697: , p_party_type in jai_rgm_thresholds.party_type%type
698: , p_party_id in jai_rgm_thresholds.party_id%type
699: , p_fin_year in jai_rgm_thresholds.fin_year%type default null

Line 709: ln_org_tan_no JAI_RGM_REGISTRATIONS.attribute_value%type;

705: , p_process_message out nocopy varchar2
706: )
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 */

Line 715: , cp_attribute_type_code JAI_RGM_REGISTRATIONS.attribute_type_code%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
716: , cp_attribute_code JAI_RGM_REGISTRATIONS.attribute_code%type
717: , cp_organization_id jai_rgm_parties.organization_id%type
718: )
719: is

Line 716: , cp_attribute_code JAI_RGM_REGISTRATIONS.attribute_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
716: , cp_attribute_code JAI_RGM_REGISTRATIONS.attribute_code%type
717: , cp_organization_id jai_rgm_parties.organization_id%type
718: )
719: is
720: select