APPS.PAY_JP_BALANCE_VIEW_PKG dependencies on PAY_DEFINED_BALANCES

Line 69: l_legislation_code pay_defined_balances.legislation_code%type;

65: p_dimension_name in varchar2,
66: p_business_group_id in number,
67: p_defined_balance_rec out nocopy t_defined_balance_rec)
68: is
69: l_legislation_code pay_defined_balances.legislation_code%type;
70: l_defined_balance_rec t_defined_balance_rec;
71: begin
72: l_legislation_code := hr_api.return_legislation_code(p_business_group_id);
73: --

Line 90: from pay_defined_balances def,

86: l_defined_balance_rec.dimension_level,
87: l_defined_balance_rec.date_type,
88: l_defined_balance_rec.period_type,
89: l_defined_balance_rec.start_date_code
90: from pay_defined_balances def,
91: pay_balance_dimensions dim
92: where def.balance_type_id = p_balance_type_id
93: and nvl(def.business_group_id, p_business_group_id) = p_business_group_id
94: and nvl(def.legislation_code, l_legislation_code) = l_legislation_code

Line 138: from pay_defined_balances def,

134: l_defined_balance_rec.dimension_level,
135: l_defined_balance_rec.date_type,
136: l_defined_balance_rec.period_type,
137: l_defined_balance_rec.start_date_code
138: from pay_defined_balances def,
139: pay_balance_dimensions dim
140: where def.defined_balance_id = p_defined_balance_id
141: and dim.balance_dimension_id = def.balance_dimension_id;
142: --