APPS.PAY_GB_ONLINE_SOE dependencies on PAY_BALANCE_PKG

Line 200: l_defined_balance_lst pay_balance_pkg.t_balance_value_tab;

196: l_st2_needed_chr varchar2(10);
197: l_found boolean;
198: balCount number;
199: --
200: l_defined_balance_lst pay_balance_pkg.t_balance_value_tab;
201: l_context_lst pay_balance_pkg.t_context_tab;
202: l_output_table pay_balance_pkg.t_detailed_bal_out_tab;
203: --
204: i number;

Line 201: l_context_lst pay_balance_pkg.t_context_tab;

197: l_found boolean;
198: balCount number;
199: --
200: l_defined_balance_lst pay_balance_pkg.t_balance_value_tab;
201: l_context_lst pay_balance_pkg.t_context_tab;
202: l_output_table pay_balance_pkg.t_detailed_bal_out_tab;
203: --
204: i number;
205: l_calculated_balance number;

Line 202: l_output_table pay_balance_pkg.t_detailed_bal_out_tab;

198: balCount number;
199: --
200: l_defined_balance_lst pay_balance_pkg.t_balance_value_tab;
201: l_context_lst pay_balance_pkg.t_context_tab;
202: l_output_table pay_balance_pkg.t_detailed_bal_out_tab;
203: --
204: i number;
205: l_calculated_balance number;
206: l_display boolean;

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

272: select distinct
273: aa.tax_unit_id tax_unit_id
274: , rr.jurisdiction_code jurisdiction_code
275: , decode(l_si_needed_chr,
276: 'Y', pay_balance_pkg.find_context('SOURCE_ID'
277: ,rr.run_result_id)
278: ,null) source_id
279: , decode(l_st_needed_chr,
280: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT'

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

276: 'Y', pay_balance_pkg.find_context('SOURCE_ID'
277: ,rr.run_result_id)
278: ,null) source_id
279: , decode(l_st_needed_chr,
280: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT'
281: ,rr.run_result_id)
282: ,null) source_text
283: , decode(l_sn_needed_chr,
284: 'Y', pay_balance_pkg.find_context('SOURCE_NUMBER'

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

280: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT'
281: ,rr.run_result_id)
282: ,null) source_text
283: , decode(l_sn_needed_chr,
284: 'Y', pay_balance_pkg.find_context('SOURCE_NUMBER'
285: ,rr.run_result_id)
286: ,null) source_number
287: , decode(l_st2_needed_chr,
288: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT2'

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

284: 'Y', pay_balance_pkg.find_context('SOURCE_NUMBER'
285: ,rr.run_result_id)
286: ,null) source_number
287: , decode(l_st2_needed_chr,
288: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT2'
289: ,rr.run_result_id)
290: ,null) source_text2
291: from pay_assignment_actions aa,
292: pay_payroll_actions pa,

Line 325: pay_balance_pkg.get_period_type_start

321: l_balance_type_lst(db.defined_balance_id).defined_balance_name:= db.defined_balance_name;
322: l_balance_type_lst(db.defined_balance_id).dimension_name := db.dimension_name;
323: l_balance_type_lst(db.defined_balance_id).defined_balance_id := db.defined_balance_id;
324: --
325: pay_balance_pkg.get_period_type_start
326: (p_period_type => db.period_type
327: ,p_effective_date => l_effective_date
328: ,p_payroll_id => l_payroll_id
329: ,p_start_date => l_temp_date);

Line 398: pay_balance_pkg.get_value (p_assignment_action_id => p_assignment_action_id

394: l_context_lst(i).SOURCE_TEXT2 := ctx.SOURCE_TEXT2;
395: end loop;
396: end if;
397:
398: pay_balance_pkg.get_value (p_assignment_action_id => p_assignment_action_id
399: ,p_defined_balance_lst => l_defined_balance_lst
400: ,p_context_lst => l_context_lst
401: ,p_output_table => l_output_table);
402: --