DBA Data[Home] [Help]

APPS.PAY_NL_PAYSLIP_ARCHIVE dependencies on PAY_BALANCE_TYPES_TL

Line 3809: ,pay_balance_types_tl pbt_tl

3805: --
3806: CURSOR csr_get_translated_bal_name (p_balance_name VARCHAR2) IS
3807: SELECT NVL(pbt_tl.reporting_name,pbt_tl.balance_name) bal_name
3808: FROM pay_balance_types pbt
3809: ,pay_balance_types_tl pbt_tl
3810: WHERE pbt.balance_name = p_balance_name
3811: AND pbt.balance_type_id = pbt_tl.balance_type_id
3812: AND pbt_tl.language = USERENV('LANG');
3813: --

Line 4663: ,pay_balance_types_tl pbt_tl

4659:
4660: CURSOR csr_get_translated_bal_name (p_balance_name VARCHAR2) IS
4661: SELECT NVL(pbt_tl.reporting_name,pbt_tl.balance_name) bal_name
4662: FROM pay_balance_types pbt
4663: ,pay_balance_types_tl pbt_tl
4664: WHERE pbt.balance_name = p_balance_name
4665: AND pbt.balance_type_id = pbt_tl.balance_type_id
4666: AND pbt_tl.language = USERENV('LANG');
4667: