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(
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:
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;