APPS.PQP_NL_ABP_TEMPLATE dependencies on PAY_BALANCE_TYPES_TL

Line 255: FROM pay_balance_types_tl

251:
252: CURSOR c_get_retro_bal_id(c_subcat IN varchar2
253: ,c_ee_er IN varchar2) IS
254: SELECT balance_type_id
255: FROM pay_balance_types_tl
256: WHERE balance_name = 'Retro '||c_subcat||' '
257: ||c_ee_er||' Contribution'
258: AND language = 'US';
259:

Line 523: pay_balance_types_tl pbtl

519: from pay_balance_feeds_v pbf,
520: pay_balance_classifications bc,
521: pay_element_classifications pec,
522: pay_element_classifications_tl pect,
523: pay_balance_types_tl pbtl
524: where nvl(pbf.balance_initialization_flag,'N') = 'N'
525: and nvl(pbf.business_group_id,
526: p_business_group_id) = p_business_group_id
527: and nvl(pbf.legislation_code, 'NL') = 'NL'