APPS.PAY_JP_BAL_UPLOAD dependencies on PAY_BALANCE_DIMENSIONS

Line 93: l_legislation_code pay_balance_dimensions.legislation_code%type;

89: l_payroll_id number;
90: l_ptp_start_date date;
91: l_asg_start_date date;
92: l_ee_start_date date;
93: l_legislation_code pay_balance_dimensions.legislation_code%type;
94: l_period_type pay_balance_dimensions.period_type%type;
95: l_start_date_code pay_balance_dimensions.start_date_code%type;
96: l_dim_start_date date;
97: l_expiry_date date;

Line 94: l_period_type pay_balance_dimensions.period_type%type;

90: l_ptp_start_date date;
91: l_asg_start_date date;
92: l_ee_start_date date;
93: l_legislation_code pay_balance_dimensions.legislation_code%type;
94: l_period_type pay_balance_dimensions.period_type%type;
95: l_start_date_code pay_balance_dimensions.start_date_code%type;
96: l_dim_start_date date;
97: l_expiry_date date;
98: begin

Line 95: l_start_date_code pay_balance_dimensions.start_date_code%type;

91: l_asg_start_date date;
92: l_ee_start_date date;
93: l_legislation_code pay_balance_dimensions.legislation_code%type;
94: l_period_type pay_balance_dimensions.period_type%type;
95: l_start_date_code pay_balance_dimensions.start_date_code%type;
96: l_dim_start_date date;
97: l_expiry_date date;
98: begin
99: hr_utility.set_location('Entering: ' || c_proc, 10);

Line 184: from pay_balance_dimensions

180: select period_type,
181: start_date_code
182: into l_period_type,
183: l_start_date_code
184: from pay_balance_dimensions
185: where dimension_name = p_dimension_name
186: and nvl(business_group_id, l_business_group_id) = l_business_group_id
187: and nvl(legislation_code, l_legislation_code) = l_legislation_code;
188: --

Line 234: l_description pay_balance_dimensions.description%type;

230: ) return boolean
231: is
232: c_proc constant varchar2(61) := c_package || 'is_supported';
233: l_is_supported boolean;
234: l_description pay_balance_dimensions.description%type;
235: l_dimension_level pay_balance_dimensions.dimension_level%type;
236: l_period_type pay_balance_dimensions.period_type%type;
237: begin
238: hr_utility.set_location('Entering: ' || c_proc, 10);

Line 235: l_dimension_level pay_balance_dimensions.dimension_level%type;

231: is
232: c_proc constant varchar2(61) := c_package || 'is_supported';
233: l_is_supported boolean;
234: l_description pay_balance_dimensions.description%type;
235: l_dimension_level pay_balance_dimensions.dimension_level%type;
236: l_period_type pay_balance_dimensions.period_type%type;
237: begin
238: hr_utility.set_location('Entering: ' || c_proc, 10);
239: --

Line 236: l_period_type pay_balance_dimensions.period_type%type;

232: c_proc constant varchar2(61) := c_package || 'is_supported';
233: l_is_supported boolean;
234: l_description pay_balance_dimensions.description%type;
235: l_dimension_level pay_balance_dimensions.dimension_level%type;
236: l_period_type pay_balance_dimensions.period_type%type;
237: begin
238: hr_utility.set_location('Entering: ' || c_proc, 10);
239: --
240: -- This SQL can possiblly raise TOO_MANY_ROWS exception

Line 255: from pay_balance_dimensions dim,

251: period_type
252: into l_description,
253: l_dimension_level,
254: l_period_type
255: from pay_balance_dimensions dim,
256: per_business_groups_perf bg
257: where dim.dimension_name = p_dimension_name
258: and bg.business_group_id(+) = dim.business_group_id
259: and nvl(dim.legislation_code, bg.legislation_code) = 'JP';