APPS.HR_BALANCES dependencies on PAY_BALANCE_TYPES_TL

Line 1612: from pay_balance_types_tl b_tl,

1608: begin
1609: --
1610: select b_tl.balance_name
1611: into l_balance_name
1612: from pay_balance_types_tl b_tl,
1613: pay_balance_types b
1614: where b_tl.balance_type_id = b.balance_type_id
1615: and userenv('LANG') = b_tl.language
1616: and b.balance_type_id = p_balance_type_id

Line 2228: This function looks in the table pay_balance_types_tl for balance type id passed to

2224: /*
2225: NAME
2226: decode_balance
2227: DESCRIPTION
2228: This function looks in the table pay_balance_types_tl for balance type id passed to
2229: the function. This function is called for the creation of the view
2230: pay_us_earnings_amounts_v which is in the payusblv.odf.
2231: */
2232:

Line 2237: from pay_balance_types_tl pbt

2233: function DECODE_balance ( p_balance_type_id number) return varchar2 is
2234: --
2235: cursor csr_balance is
2236: select balance_name
2237: from pay_balance_types_tl pbt
2238: where balance_type_id = p_balance_type_id
2239: and language = USERENV('LANG') ;
2240: --
2241: v_balance_name varchar2(80) := null;