APPS.PAY_CN_REPORT_PKG dependencies on PAY_BALANCE_TYPES

Line 50: FROM pay_balance_types pbt,

46: AND pai.action_information1 = c_balance_name;
47:
48: CURSOR csr_bal_name IS
49: SELECT nvl(pbtl.reporting_name,pbtl.balance_name)
50: FROM pay_balance_types pbt,
51: pay_balance_types_tl pbtl
52: WHERE pbt.balance_name = p_balance_name
53: AND pbt.legislation_code = 'CN'
54: AND pbt.balance_type_id = pbtl.balance_type_id

Line 51: pay_balance_types_tl pbtl

47:
48: CURSOR csr_bal_name IS
49: SELECT nvl(pbtl.reporting_name,pbtl.balance_name)
50: FROM pay_balance_types pbt,
51: pay_balance_types_tl pbtl
52: WHERE pbt.balance_name = p_balance_name
53: AND pbt.legislation_code = 'CN'
54: AND pbt.balance_type_id = pbtl.balance_type_id
55: AND pbtl.language = userenv('LANG');