[Home] [Help]
APPS.PAY_CN_PAYSLIP_ARCHIVE dependencies on PAY_BALANCE_TYPES_TL
Line 1207: ,pay_balance_types_tl bal_tl
1203: CURSOR csr_balance_rpt_name(c_balance_name VARCHAR2)
1204: IS
1205: SELECT nvl(bal_tl.reporting_name, bal_tl.balance_name)
1206: FROM pay_balance_types bal
1207: ,pay_balance_types_tl bal_tl
1208: WHERE bal.balance_name = c_balance_name
1209: AND bal.legislation_code = 'CN'
1210: AND bal.balance_type_id = bal_tl.balance_type_id
1211: AND bal_tl.language = USERENV('LANG');