[Home] [Help]
405: and UE.user_entity_id = DI.user_entity_id
406: and Ue.creator_type = 'B'
407: and UE.legislation_code = 'US';
408:
409: l_defined_balance_id pay_defined_balances.defined_balance_id%type;
410:
411: BEGIN
412: --hr_utility.trace('p_db_item_name is '||p_db_item_name);
413:
599:
600: /* cursor c_get_puerto_rico_bal is
601: select pbt.balance_name,pdb.defined_balance_id,fue.user_entity_name
602: from ff_user_entities fue,
603: pay_defined_balances pdb,
604: pay_balance_dimensions pbd,
605: pay_balance_types pbt
606: where pbt.balance_name in (
607: 'Territory Pension Annuity',
798:
799: /* cursor c_get_1099r_bal is
800: select pbt.balance_name,pdb.defined_balance_id,fue.user_entity_name
801: from ff_user_entities fue,
802: pay_defined_balances pdb,
803: pay_balance_dimensions pbd,
804: pay_balance_types pbt
805: where pbt.balance_name in (
806: 'Capital Gain',
1035: cp_balance_dimension in varchar2,
1036: cp_business_group_id in number ) is
1037: select pdb.defined_balance_id,fue.user_entity_name
1038: from ff_user_entities fue,
1039: pay_defined_balances pdb,
1040: pay_balance_dimensions pbd,
1041: pay_balance_types pbt
1042: where pbt.balance_name = cp_balance_name
1043: and pbd.database_item_suffix= cp_balance_dimension
3610:
3611: -- for the Bug#13724610
3612: l_psd_jurisdiction varchar2(16);
3613: l_psd_balance_value number;
3614: l_psd_def_bal_id pay_defined_balances.defined_balance_id%type;
3615: l_psd_user_entity_id ff_user_entities.user_entity_id%type;
3616: lv_user_entity_name ff_user_entities.user_entity_name%type;
3617: ln_business_group_id number;
3618: lv_balance_name pay_balance_types.balance_name%type;
3615: l_psd_user_entity_id ff_user_entities.user_entity_id%type;
3616: lv_user_entity_name ff_user_entities.user_entity_name%type;
3617: ln_business_group_id number;
3618: lv_balance_name pay_balance_types.balance_name%type;
3619: ln_psd_def_bal_id pay_defined_balances.defined_balance_id%type;
3620: ln_bal_value number;
3621:
3622:
3623: --