[Home] [Help]
569: select pbt.balance_name,pdb.defined_balance_id,fue.user_entity_name
570: from ff_user_entities fue,
571: pay_defined_balances pdb,
572: pay_balance_dimensions pbd,
573: pay_balance_types pbt
574: where pbt.balance_name in (
575: 'Territory Pension Annuity',
576: 'Territory Reimb Expenses',
577: 'Territory Taxable Comm',
744: where hoi.organization_id = cp_tax_unit_id
745: and hoi.org_information_context = '1099R Magnetic Report Rules';
746:
747: cursor c_balance_feed_info(cp_balance_name in varchar2) is
748: select 'Y' from pay_balance_types pbt
749: where pbt.balance_name = cp_balance_name
750: and((pbt.legislation_code = 'US' and
751: pbt.business_group_id is null)
752: or(pbt.legislation_code is null and
764: select pbt.balance_name,pdb.defined_balance_id,fue.user_entity_name
765: from ff_user_entities fue,
766: pay_defined_balances pdb,
767: pay_balance_dimensions pbd,
768: pay_balance_types pbt
769: where pbt.balance_name in (
770: 'Capital Gain',
771: 'EE Contributions Or Premiums',
772: 'Other EE Annuity Contract Amt',
992: select pdb.defined_balance_id,fue.user_entity_name
993: from ff_user_entities fue,
994: pay_defined_balances pdb,
995: pay_balance_dimensions pbd,
996: pay_balance_types pbt
997: where pbt.balance_name = cp_balance_name
998: and pbd.database_item_suffix= cp_balance_dimension
999: and pbt.balance_type_id = pdb.balance_type_id
1000: and pbd.balance_dimension_id = pdb.balance_dimension_id