DBA Data[Home] [Help]

APPS.PAY_CN_PAYSLIP_ARCHIVE dependencies on PAY_BALANCE_TYPES

Line 1312: FROM pay_balance_types bal

1308:
1309: CURSOR csr_balance_rpt_name(c_balance_name VARCHAR2)
1310: IS
1311: SELECT nvl(bal_tl.reporting_name, bal_tl.balance_name)
1312: FROM pay_balance_types bal
1313: ,pay_balance_types_tl bal_tl
1314: WHERE bal.balance_name = c_balance_name
1315: AND bal.legislation_code = 'CN'
1316: AND bal.balance_type_id = bal_tl.balance_type_id

Line 1313: ,pay_balance_types_tl bal_tl

1309: CURSOR csr_balance_rpt_name(c_balance_name VARCHAR2)
1310: IS
1311: SELECT nvl(bal_tl.reporting_name, bal_tl.balance_name)
1312: FROM pay_balance_types bal
1313: ,pay_balance_types_tl bal_tl
1314: WHERE bal.balance_name = c_balance_name
1315: AND bal.legislation_code = 'CN'
1316: AND bal.balance_type_id = bal_tl.balance_type_id
1317: AND bal_tl.language = USERENV('LANG');