APPS.PAY_US_TAXABILITY_RULES_PKG dependencies on PAY_BALANCE_TYPES

Line 759: from pay_balance_types pbt

755: cp_tax_category in varchar2,
756: cp_trash_date in date,
757: cp_classification_id in number ) is
758: select balance_type_id,balance_name
759: from pay_balance_types pbt
760: where pbt.tax_type = cp_tax_type
761: and pbt.legislation_code = 'US'
762: and exists
763: ( select 1

Line 787: ln_balance_type_id pay_balance_types.balance_type_id%TYPE := 0;

783: where session_id = userenv('sessionid');
784:
785:
786: lv_exist_flag varchar2(1) :='N';
787: ln_balance_type_id pay_balance_types.balance_type_id%TYPE := 0;
788: lv_balance_name pay_balance_types.balance_name%TYPE;
789: ln_business_group_id pay_balance_types.business_group_id%TYPE;
790: lv_legislation_code pay_balance_types.legislation_code%TYPE;
791: ld_effective_date date;

Line 788: lv_balance_name pay_balance_types.balance_name%TYPE;

784:
785:
786: lv_exist_flag varchar2(1) :='N';
787: ln_balance_type_id pay_balance_types.balance_type_id%TYPE := 0;
788: lv_balance_name pay_balance_types.balance_name%TYPE;
789: ln_business_group_id pay_balance_types.business_group_id%TYPE;
790: lv_legislation_code pay_balance_types.legislation_code%TYPE;
791: ld_effective_date date;
792:

Line 789: ln_business_group_id pay_balance_types.business_group_id%TYPE;

785:
786: lv_exist_flag varchar2(1) :='N';
787: ln_balance_type_id pay_balance_types.balance_type_id%TYPE := 0;
788: lv_balance_name pay_balance_types.balance_name%TYPE;
789: ln_business_group_id pay_balance_types.business_group_id%TYPE;
790: lv_legislation_code pay_balance_types.legislation_code%TYPE;
791: ld_effective_date date;
792:
793:

Line 790: lv_legislation_code pay_balance_types.legislation_code%TYPE;

786: lv_exist_flag varchar2(1) :='N';
787: ln_balance_type_id pay_balance_types.balance_type_id%TYPE := 0;
788: lv_balance_name pay_balance_types.balance_name%TYPE;
789: ln_business_group_id pay_balance_types.business_group_id%TYPE;
790: lv_legislation_code pay_balance_types.legislation_code%TYPE;
791: ld_effective_date date;
792:
793:
794: Begin