APPS.PAY_US_EARNINGS_TEMPLATE dependencies on PAY_BALANCE_TYPES

Line 674: FROM pay_balance_types pbt

670: AND piv.business_group_id = g_bg_id;
671: --
672: CURSOR c_get_bal_id IS -- Gets the Balance type id
673: SELECT balance_type_id
674: FROM pay_balance_types pbt
675: WHERE pbt.balance_name = p_object_name
676: AND NVL(pbt.business_group_id, g_bg_id) = g_bg_id
677: AND NVL(pbt.legislation_code, g_legislation_code) = g_legislation_code;
678: --