APPS.FEM_UNDO_UI_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 8

SELECT user_name INTO l_user_name
FROM fnd_user
WHERE user_id = p_user_id;

Line: 31

SELECT exec_status_code INTO l_undo_status
FROM (SELECT exec_status_code
      FROM  (SELECT exec_status_code
             FROM fem_ud_list_candidates
             WHERE object_id = p_object_id
             AND request_id = p_request_id
             UNION
             SELECT exec_status_code
             FROM fem_ud_list_dependents
             WHERE dependent_object_id = p_object_id
             AND dependent_request_id = p_request_id )
      ORDER by exec_status_code desc)
WHERE  rownum = 1;

Line: 62

SELECT count(*) INTO l_count FROM
FEM_TABLE_CLASS_ASSIGNMT class
WHERE class.table_name= p_table_name
AND class.table_classification_code IN ('ABM_LEDGER','PFT_LEDGER');

Line: 94

SELECT validation_status_code INTO l_status_code
FROM fem_ud_prview_candidates
WHERE ud_session_id = p_ud_session_id
AND object_id = p_object_id
AND request_id = p_request_id;

Line: 105

SELECT count(*) into l_count
FROM fem_ud_prview_dependents
WHERE validation_status_code <> 'FEM_UD_VALID_TXT'
AND request_id = p_request_id
AND object_id = p_object_id
AND ud_session_id = p_ud_session_id;