APPS.PAY_KW_SOE dependencies on PAY_BALANCE_PKG

Line 92: l_defined_balance_lst pay_balance_pkg.t_balance_value_tab;

88: l_meaning_uom varchar2(100);
89: l_currency_code varchar2(100);
90: balCount number;
91: --
92: l_defined_balance_lst pay_balance_pkg.t_balance_value_tab;
93: l_context_lst pay_balance_pkg.t_context_tab;
94: l_output_table pay_balance_pkg.t_detailed_bal_out_tab;
95: --
96: i number;

Line 93: l_context_lst pay_balance_pkg.t_context_tab;

89: l_currency_code varchar2(100);
90: balCount number;
91: --
92: l_defined_balance_lst pay_balance_pkg.t_balance_value_tab;
93: l_context_lst pay_balance_pkg.t_context_tab;
94: l_output_table pay_balance_pkg.t_detailed_bal_out_tab;
95: --
96: i number;
97: l_nat varchar2(30) ;

Line 94: l_output_table pay_balance_pkg.t_detailed_bal_out_tab;

90: balCount number;
91: --
92: l_defined_balance_lst pay_balance_pkg.t_balance_value_tab;
93: l_context_lst pay_balance_pkg.t_context_tab;
94: l_output_table pay_balance_pkg.t_detailed_bal_out_tab;
95: --
96: i number;
97: l_nat varchar2(30) ;
98: l_local_nat varchar2(30);

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

186: select distinct
187: aa.tax_unit_id tax_unit_id
188: , rr.jurisdiction_code jurisdiction_code
189: , decode(l_si_needed_chr,
190: 'Y', pay_balance_pkg.find_context('SOURCE_ID'
191: ,rr.run_result_id)
192: ,null) source_id
193: , decode(l_st_needed_chr,
194: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT'

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

190: 'Y', pay_balance_pkg.find_context('SOURCE_ID'
191: ,rr.run_result_id)
192: ,null) source_id
193: , decode(l_st_needed_chr,
194: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT'
195: ,rr.run_result_id)
196: ,null) source_text
197: , decode(l_sn_needed_chr,
198: 'Y', pay_balance_pkg.find_context('SOURCE_NUMBER'

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

194: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT'
195: ,rr.run_result_id)
196: ,null) source_text
197: , decode(l_sn_needed_chr,
198: 'Y', pay_balance_pkg.find_context('SOURCE_NUMBER'
199: ,rr.run_result_id)
200: ,null) source_number
201: , decode(l_st2_needed_chr,
202: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT2'

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

198: 'Y', pay_balance_pkg.find_context('SOURCE_NUMBER'
199: ,rr.run_result_id)
200: ,null) source_number
201: , decode(l_st2_needed_chr,
202: 'Y', pay_balance_pkg.find_context('SOURCE_TEXT2'
203: ,rr.run_result_id)
204: ,null) source_text2
205: from pay_assignment_actions aa,
206: pay_payroll_actions pa,

Line 282: pay_balance_pkg.get_period_type_start

278: db.defined_balance_id;
279: l_balance_type_lst(db.defined_balance_id).meaning_uom:=
280: db.meaning;
281: --
282: pay_balance_pkg.get_period_type_start
283: (p_period_type => db.period_type
284: ,p_effective_date => l_effective_date
285: ,p_payroll_id => l_payroll_id
286: ,p_start_date => l_temp_date);

Line 393: pay_balance_pkg.get_value (p_assignment_action_id => p_assignment_action_id

389: l_context_lst(i).SOURCE_TEXT2 := ctx.SOURCE_TEXT2;
390: end loop;
391: end if;
392: --
393: pay_balance_pkg.get_value (p_assignment_action_id => p_assignment_action_id
394: ,p_defined_balance_lst => l_defined_balance_lst
395: ,p_context_lst => l_context_lst
396: ,p_output_table => l_output_table);
397: --