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 172: l_defined_balance_lst pay_balance_pkg.t_balance_value_tab;

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

Line 173: l_context_lst pay_balance_pkg.t_context_tab;

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

Line 174: l_output_table pay_balance_pkg.t_detailed_bal_out_tab;

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

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

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

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

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

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

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

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

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

Line 341: pay_balance_pkg.get_period_type_start

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

Line 438: pay_balance_pkg.get_value (p_assignment_action_id => p_assignment_action_id

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