APPS.JTF_IH_PUB_PS dependencies on JTF_IH_REASONS_B

Line 157: FROM jtf_ih_reasons_B

153: l_count := 0;
154: IF ((p_int_val_rec.reason_id IS NOT NULL) AND (p_int_val_rec.reason_id <> fnd_api.g_miss_num)) THEN
155: BEGIN
156: SELECT count(*) into l_count
157: FROM jtf_ih_reasons_B
158: WHERE reason_id = p_int_val_rec.reason_id;
159: IF (l_count <= 0) THEN
160: x_return_status := fnd_api.g_ret_sts_error;
161: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_int_val_rec.reason_id),

Line 476: FROM jtf_ih_reasons_B

472: l_count := 0;
473: IF ((p_act_val_rec.reason_id IS NOT NULL) AND (p_act_val_rec.reason_id <> fnd_api.g_miss_num)) THEN
474: BEGIN
475: SELECT count(*) into l_count
476: FROM jtf_ih_reasons_B
477: WHERE reason_id = p_act_val_rec.reason_id;
478: IF (l_count <= 0) THEN
479: x_return_status := fnd_api.g_ret_sts_error;
480: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_act_val_rec.reason_id),