APPS.PAY_ZA_PAYROLL_ACTION_PKG dependencies on PAY_BALANCE_TYPES

Line 58: pay_balance_types PBT

54: defined_balance_id
55: FROM
56: pay_defined_balances PDB,
57: pay_balance_dimensions PBD,
58: pay_balance_types PBT
59: WHERE PBT.balance_name = p_balance_type
60: AND nvl(PBT.legislation_code, l_legislation_code) = l_legislation_code -- Bug 4377803; added nvl function
61: AND PDB.balance_type_id = PBT.balance_type_id
62: AND PBD.balance_dimension_id = PDB.balance_dimension_id

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 89: pay_balance_types PBT,

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
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 (+)

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');