APPS.PAY_AE_SOE dependencies on PAY_BALANCE_PKG

Line 96: l_defined_balance_lst pay_balance_pkg.t_balance_value_tab;

92: l_meaning_uom varchar2(100);
93: l_currency_code varchar2(100);
94: balCount number;
95: --
96: l_defined_balance_lst pay_balance_pkg.t_balance_value_tab;
97: l_context_lst pay_balance_pkg.t_context_tab;
98: l_output_table pay_balance_pkg.t_detailed_bal_out_tab;
99: --
100: i number;

Line 97: l_context_lst pay_balance_pkg.t_context_tab;

93: l_currency_code varchar2(100);
94: balCount number;
95: --
96: l_defined_balance_lst pay_balance_pkg.t_balance_value_tab;
97: l_context_lst pay_balance_pkg.t_context_tab;
98: l_output_table pay_balance_pkg.t_detailed_bal_out_tab;
99: --
100: i number;
101:

Line 98: l_output_table pay_balance_pkg.t_detailed_bal_out_tab;

94: balCount number;
95: --
96: l_defined_balance_lst pay_balance_pkg.t_balance_value_tab;
97: l_context_lst pay_balance_pkg.t_context_tab;
98: l_output_table pay_balance_pkg.t_detailed_bal_out_tab;
99: --
100: i number;
101:
102: l_nat varchar2(80);

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

191: select distinct
192: aa.tax_unit_id tax_unit_id
193: , rr.jurisdiction_code jurisdiction_code
194: , decode(l_si_needed_chr,
195: 'Y', pay_balance_pkg.find_context('SOURCE_ID'
196: ,rr.run_result_id)
197: ,null) source_id
198: , decode(l_st_needed_chr,
199: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT'

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

195: 'Y', pay_balance_pkg.find_context('SOURCE_ID'
196: ,rr.run_result_id)
197: ,null) source_id
198: , decode(l_st_needed_chr,
199: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT'
200: ,rr.run_result_id)
201: ,null) source_text
202: , decode(l_sn_needed_chr,
203: 'Y', pay_balance_pkg.find_context('SOURCE_NUMBER'

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

199: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT'
200: ,rr.run_result_id)
201: ,null) source_text
202: , decode(l_sn_needed_chr,
203: 'Y', pay_balance_pkg.find_context('SOURCE_NUMBER'
204: ,rr.run_result_id)
205: ,null) source_number
206: , decode(l_st2_needed_chr,
207: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT2'

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

203: 'Y', pay_balance_pkg.find_context('SOURCE_NUMBER'
204: ,rr.run_result_id)
205: ,null) source_number
206: , decode(l_st2_needed_chr,
207: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT2'
208: ,rr.run_result_id)
209: ,null) source_text2
210: from pay_assignment_actions aa,
211: pay_payroll_actions pa,

Line 289: pay_balance_pkg.get_period_type_start

285: db.defined_balance_id;
286: l_balance_type_lst(db.defined_balance_id).meaning_uom:=
287: db.meaning;
288: --
289: pay_balance_pkg.get_period_type_start
290: (p_period_type => db.period_type
291: ,p_effective_date => l_effective_date
292: ,p_payroll_id => l_payroll_id
293: ,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: --