APPS.PQP_EARNINGS_TEMPLATE dependencies on PAY_BALANCE_TYPES

Line 519: FROM pay_balance_types pbt

515: AND piv.business_group_id = g_bg_id;
516: --
517: CURSOR c_get_bal_id IS -- Gets the Balance type id
518: SELECT balance_type_id
519: FROM pay_balance_types pbt
520: WHERE pbt.balance_name = p_object_name
521: AND NVL(pbt.business_group_id, g_bg_id) = g_bg_id
522: AND NVL(pbt.legislation_code, g_legislation_code) = g_legislation_code;
523: --

Line 568: pay_balance_types pbt

564: --
565: CURSOR get_reg_feeds IS
566: SELECT distinct pbf.balance_type_id
567: FROM pay_balance_feeds_f pbf,
568: pay_balance_types pbt
569: WHERE p_ele_eff_start_date BETWEEN pbf.effective_start_date
570: AND pbf.effective_end_date
571: AND ((pbt.business_group_id is NULL AND pbt.legislation_code = 'US')
572: OR (pbt.business_group_id = g_bg_id AND pbt.legislation_code is NULL))