DBA Data[Home] [Help]

APPS.PAY_JP_CREATE_CMA_PKG dependencies on PAY_JP_BALANCE_PKG

Line 184: l_non_res_date := pay_jp_balance_pkg.get_entry_value_date(

180:
181: --
182: -- Derive Non-resident flag as of Upload Date
183: --
184: l_non_res_date := pay_jp_balance_pkg.get_entry_value_date(
185: p_input_value_id => g_non_res_date_iv_id,
186: p_assignment_id => p_assignment_id,
187: p_effective_date => p_upload_date);
188: l_res_date := nvl(pay_jp_balance_pkg.get_entry_value_date(

Line 188: l_res_date := nvl(pay_jp_balance_pkg.get_entry_value_date(

184: l_non_res_date := pay_jp_balance_pkg.get_entry_value_date(
185: p_input_value_id => g_non_res_date_iv_id,
186: p_assignment_id => p_assignment_id,
187: p_effective_date => p_upload_date);
188: l_res_date := nvl(pay_jp_balance_pkg.get_entry_value_date(
189: p_input_value_id => g_res_date_iv_id,
190: p_assignment_id => p_assignment_id,
191: p_effective_date => p_upload_date), TO_DATE('47121231','YYYYMMDD'));
192:

Line 200: l_non_res_flag := nvl(pay_jp_balance_pkg.get_entry_value_char(

196: else
197: l_non_res_flag := 'N';
198: end if;
199: else
200: l_non_res_flag := nvl(pay_jp_balance_pkg.get_entry_value_char(
201: p_input_value_id => g_non_res_iv_id,
202: p_assignment_id => p_assignment_id,
203: p_effective_date => p_upload_date), 'N');
204: end if;