APPS.PAY_ZA_PAYROLL_ACTION_PKG dependencies on PAY_BALANCE_TYPES_TL

Line 84: l_reporting_name pay_balance_types_tl.REPORTING_NAME%type;

80: -- bug no 4276047
81: FUNCTION get_balance_reporting_name (p_balance_type in varchar2
82: ) return varchar2 is
83: l_legislation_code varchar2(30) := 'ZA';
84: l_reporting_name pay_balance_types_tl.REPORTING_NAME%type;
85: Cursor get_bal_rpt_name is
86: SELECT
87: substr( nvl(pbtl.REPORTING_NAME, nvl(pbt.REPORTING_NAME,pbt.balance_name)),1,50)
88: FROM

Line 90: pay_balance_types_tl PBTl

86: SELECT
87: substr( nvl(pbtl.REPORTING_NAME, nvl(pbt.REPORTING_NAME,pbt.balance_name)),1,50)
88: FROM
89: pay_balance_types PBT,
90: pay_balance_types_tl PBTl
91: WHERE PBT.balance_name = p_balance_type
92: AND nvl(PBT.legislation_code, l_legislation_code) = l_legislation_code -- Bug 4377803; added nvl function
93: and pbt.BALANCE_TYPE_ID = pbtl.BALANCE_TYPE_ID (+)
94: and pbtl.LANGUAGE(+) = userenv('LANG');