APPS.CN_PLAN_ELEMENT_PVT dependencies on CN_LOOKUPS

Line 436: select meaning into l_temp_old from cn_lookups

432:
433: -- CHECK IF PAID THRU PARTY WAS UPDATED
434: IF (p_plan_element_old.payee_assign_flag <> p_plan_element_new.payee_assign_flag) THEN
435: fnd_message.set_name ('CN', 'CNR12_NOTE_PE_THIRDPARY_UPDATE');
436: select meaning into l_temp_old from cn_lookups
437: where lookup_code = NVL(p_plan_element_old.payee_assign_flag, 'N')
438: and lookup_type = 'YES_NO';
439: select meaning into l_temp_new from cn_lookups
440: where lookup_code = NVL(p_plan_element_new.payee_assign_flag, 'N')

Line 439: select meaning into l_temp_new from cn_lookups

435: fnd_message.set_name ('CN', 'CNR12_NOTE_PE_THIRDPARY_UPDATE');
436: select meaning into l_temp_old from cn_lookups
437: where lookup_code = NVL(p_plan_element_old.payee_assign_flag, 'N')
438: and lookup_type = 'YES_NO';
439: select meaning into l_temp_new from cn_lookups
440: where lookup_code = NVL(p_plan_element_new.payee_assign_flag, 'N')
441: and lookup_type = 'YES_NO';
442: fnd_message.set_token('PE_OLD_PAYEE', l_temp_old);
443: fnd_message.set_token('PE_NEW_PAYEE', l_temp_new);

Line 889: l_lookup_type CN_LOOKUPS.lookup_type%TYPE;

885: --l_api_name CONSTANT VARCHAR2 (30) := 'Valid_Lookup_Code';
886: l_tmp_exist NUMBER := 0;
887: l_temp VARCHAR2 (1000) := NULL;
888: l_plan_element CN_CHK_PLAN_ELEMENT_PKG.pe_rec_type;
889: l_lookup_type CN_LOOKUPS.lookup_type%TYPE;
890: BEGIN
891: -- set the Status
892: x_return_status := fnd_api.g_ret_sts_success;
893: l_lookup_type := '';

Line 911: FROM cn_lookups

907: -- Check/Valid Incentive Type
908: l_lookup_type := 'INCENTIVE_TYPE';
909: SELECT COUNT (*)
910: INTO l_tmp_exist
911: FROM cn_lookups
912: WHERE lookup_type = l_lookup_type
913: AND lookup_code = p_plan_element.incentive_type_code;
914:
915: IF (l_tmp_exist = 0)

Line 930: FROM cn_lookups

926:
927: l_lookup_type := 'PAYMENT_GROUP_CODE';
928: SELECT COUNT (*)
929: INTO l_tmp_exist
930: FROM cn_lookups
931: WHERE lookup_type = l_lookup_type
932: AND lookup_code = p_plan_element.payment_group_code;
933:
934: IF (l_tmp_exist = 0)

Line 949: FROM cn_lookups

945:
946: BEGIN
947: SELECT lookup_code
948: INTO l_temp
949: FROM cn_lookups
950: WHERE lookup_type = 'QUOTA_GROUP_CODE' AND lookup_code = p_plan_element.quota_group_code;
951: EXCEPTION
952: WHEN NO_DATA_FOUND
953: THEN

Line 970: FROM cn_lookups

966:
967: BEGIN
968: SELECT lookup_code
969: INTO l_temp
970: FROM cn_lookups
971: WHERE lookup_type = 'PLAN_ELEMENT_STATUS_TYPE' AND lookup_code = p_plan_element.quota_status;
972: EXCEPTION
973: WHEN NO_DATA_FOUND
974: THEN

Line 992: FROM cn_lookups

988: -- Validate Indirect Credit
989: l_lookup_type := 'INDIRECT_CREDIT_TYPE';
990: SELECT COUNT (*)
991: INTO l_tmp_exist
992: FROM cn_lookups
993: WHERE lookup_type = l_lookup_type
994: AND lookup_code = p_plan_element.indirect_credit_code;
995:
996: IF (l_tmp_exist = 0)