DBA Data[Home] [Help]

APPS.QA_VALIDATION_API dependencies on QA_PLAN_CHAR_ACTION_OUTPUTS

Line 2473: FROM qa_plan_char_action_outputs qpcao, qa_plan_chars_v qpcv

2469:
2470: --move the lookup of the datatype into this cursor
2471: /* CURSOR c1 (token VARCHAR2, pca_id NUMBER) IS
2472: SELECT qpcao.char_id, qpcv.datatype
2473: FROM qa_plan_char_action_outputs qpcao, qa_plan_chars_v qpcv
2474: WHERE plan_char_action_id = pca_id AND
2475: token_name = token AND
2476: qpcao.char_id = qpcv.char_id; */
2477:

Line 2483: FROM qa_plan_char_action_outputs qpcao,

2479: CURSOR c1 (token VARCHAR2, pca_id NUMBER) IS
2480: SELECT
2481: qpcao.char_id,
2482: qpcv.datatype
2483: FROM qa_plan_char_action_outputs qpcao,
2484: qa_chars qpcv
2485: WHERE plan_char_action_id = pca_id
2486: AND token_name = token
2487: AND qpcao.char_id = qpcv.char_id;