APPS.PAY_JP_BALANCE_VIEW_PKG dependencies on PAY_BALANCE_DIMENSIONS

Line 17: dimension_name pay_balance_dimensions.dimension_name%type,

13: --
14: type t_defined_balance_rec is record(
15: defined_balance_id number,
16: balance_type_id number,
17: dimension_name pay_balance_dimensions.dimension_name%type,
18: business_group_id number,
19: dimension_level pay_balance_dimensions.dimension_level%type,
20: date_type varchar2(30),
21: period_type pay_balance_dimensions.period_type%type,

Line 19: dimension_level pay_balance_dimensions.dimension_level%type,

15: defined_balance_id number,
16: balance_type_id number,
17: dimension_name pay_balance_dimensions.dimension_name%type,
18: business_group_id number,
19: dimension_level pay_balance_dimensions.dimension_level%type,
20: date_type varchar2(30),
21: period_type pay_balance_dimensions.period_type%type,
22: start_date_code pay_balance_dimensions.start_date_code%type);
23: g_defined_balance_rec t_defined_balance_rec;

Line 21: period_type pay_balance_dimensions.period_type%type,

17: dimension_name pay_balance_dimensions.dimension_name%type,
18: business_group_id number,
19: dimension_level pay_balance_dimensions.dimension_level%type,
20: date_type varchar2(30),
21: period_type pay_balance_dimensions.period_type%type,
22: start_date_code pay_balance_dimensions.start_date_code%type);
23: g_defined_balance_rec t_defined_balance_rec;
24: -- ----------------------------------------------------------------------------
25: -- |-------------------------< get_assignment_info >--------------------------|

Line 22: start_date_code pay_balance_dimensions.start_date_code%type);

18: business_group_id number,
19: dimension_level pay_balance_dimensions.dimension_level%type,
20: date_type varchar2(30),
21: period_type pay_balance_dimensions.period_type%type,
22: start_date_code pay_balance_dimensions.start_date_code%type);
23: g_defined_balance_rec t_defined_balance_rec;
24: -- ----------------------------------------------------------------------------
25: -- |-------------------------< get_assignment_info >--------------------------|
26: -- ----------------------------------------------------------------------------

Line 91: pay_balance_dimensions dim

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
95: and dim.balance_dimension_id = def.balance_dimension_id

Line 139: pay_balance_dimensions dim

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: --
143: l_defined_balance_rec.defined_balance_id := p_defined_balance_id;