APPS.PAY_ELEMENT_TYPES_SWI_ND dependencies on PAY_BALANCE_TYPES

Line 747: PAY_BALANCE_TYPES BT,

743: ,bf.scale
744: ,et.element_type_id
745: ,bt.legislation_code
746: from PAY_BALANCE_FEEDS_F BF,
747: PAY_BALANCE_TYPES BT,
748: PAY_INPUT_VALUES_F IV,
749: PAY_ELEMENT_TYPES_F ET,
750: PAY_ELEMENT_CLASSIFICATIONS EC,
751: --FND_LOOKUPS HL,

Line 771: from pay_balance_types

767: order by et.element_name;
768: -- To get the balance type id
769: cursor c2_balance_type is
770: select balance_type_id
771: from pay_balance_types
772: where business_group_id = p_business_group_id
773: and ( balance_name like p_balance_name || ' Eligible Comp'
774: OR balance_name like p_balance_name || ' Roth Eligible Comp'
775: OR balance_name like p_balance_name || ' AT Eligible Comp');