DBA Data[Home] [Help]

APPS.CN_PLAN_ELEMENT_PVT dependencies on CN_CREDIT_TYPES_VL

Line 408: select name into l_temp_old from cn_credit_types_vl

404:
405: -- CHECK IF CREDIT TYPE WAS UPDATED
406: IF (p_plan_element_old.credit_type_id <> p_plan_element_new.credit_type_id) THEN
407: fnd_message.set_name ('CN', 'CNR12_NOTE_PE_CRTYPE_UPDATE');
408: select name into l_temp_old from cn_credit_types_vl
409: where credit_type_id = p_plan_element_old.credit_type_id
410: and org_id = p_plan_element_old.org_id;
411: select name into l_temp_new from cn_credit_types_vl
412: where credit_type_id = p_plan_element_new.credit_type_id

Line 411: select name into l_temp_new from cn_credit_types_vl

407: fnd_message.set_name ('CN', 'CNR12_NOTE_PE_CRTYPE_UPDATE');
408: select name into l_temp_old from cn_credit_types_vl
409: where credit_type_id = p_plan_element_old.credit_type_id
410: and org_id = p_plan_element_old.org_id;
411: select name into l_temp_new from cn_credit_types_vl
412: where credit_type_id = p_plan_element_new.credit_type_id
413: and org_id = p_plan_element_new.org_id;
414: fnd_message.set_token('PE_OLD_CREDIT', l_temp_old);
415: fnd_message.set_token('PE_NEW_CREDIT', l_temp_new);