DBA Data[Home] [Help]

APPS.CSI_II_RELATIONSHIPS_PVT dependencies on CSI_II_RELATION_TYPES

Line 6813: FROM csi_ii_relation_types

6809: IF ((p_relationship_type_code IS NOT NULL) AND (p_relationship_type_code <> fnd_api.g_miss_char)) THEN
6810: BEGIN
6811: SELECT 'x'
6812: INTO l_dummy
6813: FROM csi_ii_relation_types
6814: WHERE relationship_type_code=p_relationship_type_code;
6815:
6816: IF SQL%FOUND THEN
6817: x_return_status := fnd_api.g_ret_sts_success;

Line 6840: FROM csi_ii_relation_types

6836: IF ((p_relationship_type_code IS NOT NULL) AND (p_relationship_type_code <> fnd_api.g_miss_char)) THEN
6837: BEGIN
6838: SELECT 'x'
6839: INTO l_dummy
6840: FROM csi_ii_relation_types
6841: WHERE relationship_type_code=p_relationship_type_code;
6842: IF SQL%FOUND THEN
6843: x_return_status := fnd_api.g_ret_sts_success;
6844: END IF;

Line 7401: FROM csi_ii_relation_types

7397: (p_rel_history_tbl(tab_row).relationship_type_code <> FND_API.G_MISS_CHAR) ) THEN
7398: BEGIN
7399: SELECT name
7400: INTO p_rel_history_tbl(tab_row).relationship_type
7401: FROM csi_ii_relation_types
7402: WHERE relationship_type_code = p_rel_history_tbl(tab_row).relationship_type_code;
7403: EXCEPTION
7404: WHEN OTHERS THEN
7405: NULL;