DBA Data[Home] [Help]

APPS.PAY_US_GARN_UPGRADE dependencies on PAY_BALANCE_TYPES

Line 704: from pay_balance_types

700: -- Get Balance Type Ids
701: cursor c_balance_type_id(cp_ele_name varchar2,
702: cp_business_grp_id number) IS
703: select balance_type_id
704: from pay_balance_types
705: where business_group_id = cp_business_grp_id
706: and balance_name in (cp_ele_name,
707: cp_ele_name || ' Accrued',
708: cp_ele_name || ' Accrued Fees',

Line 892: from pay_balance_types

888: */
889: delete
890: from pay_balance_feeds_f
891: where balance_type_id in (select balance_type_id
892: from pay_balance_types
893: where balance_name in
894: (p_new_ele_name,
895: p_new_ele_name || ' Accrued',
896: p_new_ele_name || ' Accrued Fees',