DBA Data[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');