APPS.PAY_GB_ONLINE_SOE dependencies on PAY_BALANCE_PKG

Line 205: l_defined_balance_lst pay_balance_pkg.t_balance_value_tab;

201: l_st2_needed_chr varchar2(10);
202: l_found boolean;
203: balCount number;
204: --
205: l_defined_balance_lst pay_balance_pkg.t_balance_value_tab;
206: l_context_lst pay_balance_pkg.t_context_tab;
207: l_output_table pay_balance_pkg.t_detailed_bal_out_tab;
208: --
209: i number;

Line 206: l_context_lst pay_balance_pkg.t_context_tab;

202: l_found boolean;
203: balCount number;
204: --
205: l_defined_balance_lst pay_balance_pkg.t_balance_value_tab;
206: l_context_lst pay_balance_pkg.t_context_tab;
207: l_output_table pay_balance_pkg.t_detailed_bal_out_tab;
208: --
209: i number;
210: l_calculated_balance number;

Line 207: l_output_table pay_balance_pkg.t_detailed_bal_out_tab;

203: balCount number;
204: --
205: l_defined_balance_lst pay_balance_pkg.t_balance_value_tab;
206: l_context_lst pay_balance_pkg.t_context_tab;
207: l_output_table pay_balance_pkg.t_detailed_bal_out_tab;
208: --
209: i number;
210: l_calculated_balance number;
211: l_display boolean;

Line 281: 'Y', pay_balance_pkg.find_context('SOURCE_ID'

277: select distinct
278: aa.tax_unit_id tax_unit_id
279: , rr.jurisdiction_code jurisdiction_code
280: , decode(l_si_needed_chr,
281: 'Y', pay_balance_pkg.find_context('SOURCE_ID'
282: ,rr.run_result_id)
283: ,null) source_id
284: , decode(l_st_needed_chr,
285: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT'

Line 285: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT'

281: 'Y', pay_balance_pkg.find_context('SOURCE_ID'
282: ,rr.run_result_id)
283: ,null) source_id
284: , decode(l_st_needed_chr,
285: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT'
286: ,rr.run_result_id)
287: ,null) source_text
288: , decode(l_sn_needed_chr,
289: 'Y', pay_balance_pkg.find_context('SOURCE_NUMBER'

Line 289: 'Y', pay_balance_pkg.find_context('SOURCE_NUMBER'

285: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT'
286: ,rr.run_result_id)
287: ,null) source_text
288: , decode(l_sn_needed_chr,
289: 'Y', pay_balance_pkg.find_context('SOURCE_NUMBER'
290: ,rr.run_result_id)
291: ,null) source_number
292: , decode(l_st2_needed_chr,
293: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT2'

Line 293: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT2'

289: 'Y', pay_balance_pkg.find_context('SOURCE_NUMBER'
290: ,rr.run_result_id)
291: ,null) source_number
292: , decode(l_st2_needed_chr,
293: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT2'
294: ,rr.run_result_id)
295: ,null) source_text2
296: from pay_assignment_actions aa,
297: pay_payroll_actions pa,

Line 330: pay_balance_pkg.get_period_type_start

326: l_balance_type_lst(db.defined_balance_id).defined_balance_name:= db.defined_balance_name;
327: l_balance_type_lst(db.defined_balance_id).dimension_name := db.dimension_name;
328: l_balance_type_lst(db.defined_balance_id).defined_balance_id := db.defined_balance_id;
329: --
330: pay_balance_pkg.get_period_type_start
331: (p_period_type => db.period_type
332: ,p_effective_date => l_effective_date
333: ,p_payroll_id => l_payroll_id
334: ,p_start_date => l_temp_date);

Line 403: pay_balance_pkg.get_value (p_assignment_action_id => p_assignment_action_id

399: l_context_lst(i).SOURCE_TEXT2 := ctx.SOURCE_TEXT2;
400: end loop;
401: end if;
402:
403: pay_balance_pkg.get_value (p_assignment_action_id => p_assignment_action_id
404: ,p_defined_balance_lst => l_defined_balance_lst
405: ,p_context_lst => l_context_lst
406: ,p_output_table => l_output_table);
407: --