DBA Data[Home] [Help]

APPS.PAY_US_GARN_UPGRADE dependencies on PAY_BALANCE_TYPES

Line 697: from pay_balance_types

693: -- Get Balance Type Ids
694: cursor c_balance_type_id(cp_ele_name varchar2,
695: cp_business_grp_id number) IS
696: select balance_type_id
697: from pay_balance_types
698: where business_group_id = cp_business_grp_id
699: and balance_name in (cp_ele_name,
700: cp_ele_name || ' Accrued',
701: cp_ele_name || ' Accrued Fees',

Line 885: from pay_balance_types

881: */
882: delete
883: from pay_balance_feeds_f
884: where balance_type_id in (select balance_type_id
885: from pay_balance_types
886: where balance_name in
887: (p_new_ele_name,
888: p_new_ele_name || ' Accrued',
889: p_new_ele_name || ' Accrued Fees',