APPS.PAY_SA_SOE dependencies on PAY_BALANCE_PKG

Line 32: l_balvalue := pay_balance_pkg.get_value(l_defbal_id, p_assignment_action_id);

28: BEGIN
29: --
30: l_defbal_id :=
31: PAY_SA_ARCHIVE.GET_DEFINED_BALANCE_ID('GOSI_REFERENCE_EARNINGS_ASG_YTD');
32: l_balvalue := pay_balance_pkg.get_value(l_defbal_id, p_assignment_action_id);
33: OPEN get_lower_base(p_effective_date);
34: FETCH get_lower_base INTO l_lower_base;
35: CLOSE get_lower_base;
36: OPEN get_upper_base(p_effective_date);

Line 169: l_defined_balance_lst pay_balance_pkg.t_balance_value_tab;

165: l_meaning_uom varchar2(100);
166: l_currency_code varchar2(100);
167: balCount number;
168: --
169: l_defined_balance_lst pay_balance_pkg.t_balance_value_tab;
170: l_context_lst pay_balance_pkg.t_context_tab;
171: l_output_table pay_balance_pkg.t_detailed_bal_out_tab;
172: --
173: i number;

Line 170: l_context_lst pay_balance_pkg.t_context_tab;

166: l_currency_code varchar2(100);
167: balCount number;
168: --
169: l_defined_balance_lst pay_balance_pkg.t_balance_value_tab;
170: l_context_lst pay_balance_pkg.t_context_tab;
171: l_output_table pay_balance_pkg.t_detailed_bal_out_tab;
172: --
173: i number;
174: l_rr_processed varchar2(1);

Line 171: l_output_table pay_balance_pkg.t_detailed_bal_out_tab;

167: balCount number;
168: --
169: l_defined_balance_lst pay_balance_pkg.t_balance_value_tab;
170: l_context_lst pay_balance_pkg.t_context_tab;
171: l_output_table pay_balance_pkg.t_detailed_bal_out_tab;
172: --
173: i number;
174: l_rr_processed varchar2(1);
175: l_GOSI_ele_id number;

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

262: select distinct
263: aa.tax_unit_id tax_unit_id
264: , rr.jurisdiction_code jurisdiction_code
265: , decode(l_si_needed_chr,
266: 'Y', pay_balance_pkg.find_context('SOURCE_ID'
267: ,rr.run_result_id)
268: ,null) source_id
269: , decode(l_st_needed_chr,
270: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT'

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

266: 'Y', pay_balance_pkg.find_context('SOURCE_ID'
267: ,rr.run_result_id)
268: ,null) source_id
269: , decode(l_st_needed_chr,
270: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT'
271: ,rr.run_result_id)
272: ,null) source_text
273: , decode(l_sn_needed_chr,
274: 'Y', pay_balance_pkg.find_context('SOURCE_NUMBER'

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

270: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT'
271: ,rr.run_result_id)
272: ,null) source_text
273: , decode(l_sn_needed_chr,
274: 'Y', pay_balance_pkg.find_context('SOURCE_NUMBER'
275: ,rr.run_result_id)
276: ,null) source_number
277: , decode(l_st2_needed_chr,
278: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT2'

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

274: 'Y', pay_balance_pkg.find_context('SOURCE_NUMBER'
275: ,rr.run_result_id)
276: ,null) source_number
277: , decode(l_st2_needed_chr,
278: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT2'
279: ,rr.run_result_id)
280: ,null) source_text2
281: from pay_assignment_actions aa,
282: pay_payroll_actions pa,

Line 338: pay_balance_pkg.get_period_type_start

334: db.defined_balance_id;
335: l_balance_type_lst(db.defined_balance_id).meaning_uom:=
336: db.meaning;
337: --
338: pay_balance_pkg.get_period_type_start
339: (p_period_type => db.period_type
340: ,p_effective_date => l_effective_date
341: ,p_payroll_id => l_payroll_id
342: ,p_start_date => l_temp_date);

Line 435: pay_balance_pkg.get_value (p_assignment_action_id => p_assignment_action_id

431: l_context_lst(i).SOURCE_TEXT2 := ctx.SOURCE_TEXT2;
432: end loop;
433: end if;
434: --
435: pay_balance_pkg.get_value (p_assignment_action_id => p_assignment_action_id
436: ,p_defined_balance_lst => l_defined_balance_lst
437: ,p_context_lst => l_context_lst
438: ,p_output_table => l_output_table);
439: --