DBA Data[Home] [Help]

APPS.QA_SS_CORE dependencies on QA_PLAN_CHARS

Line 405: FROM qa_plan_chars qpc

401: -- collection element prompt for error messages
402:
403: cursor chars_cur IS
404: SELECT qpc.char_id
405: FROM qa_plan_chars qpc
406: where qpc.plan_id = hid_planid
407: AND qpc.enabled_flag = 1
408: ORDER BY qpc.prompt_sequence;
409:

Line 1029: from qa_plan_chars qpc, qa_chars qc

1025:
1026: CURSOR char_cur IS
1027: select qpc.prompt_sequence, qc.char_id, qc.name, NVL(qc.developer_name, qc.name) AS cname, qc.sql_validation_string, qpc.prompt, qc.display_length, qpc.default_value,
1028: qpc.enabled_flag, qc.data_entry_hint
1029: from qa_plan_chars qpc, qa_chars qc
1030: where qpc.plan_id = plan_id_i
1031: AND qpc.char_id = qc.char_id
1032: AND qpc.enabled_flag = 1
1033: ORDER BY qpc.prompt_sequence;

Line 1784: from qa_plan_chars qpc, qa_chars qc

1780: ss_w_c varchar2(5000) := NULL;
1781:
1782: CURSOR char_cur IS
1783: select qpc.prompt_sequence, qc.char_id, qc.name, qc.prompt, qpc.enabled_flag
1784: from qa_plan_chars qpc, qa_chars qc
1785: where qpc.plan_id = plan_id_i
1786: AND qpc.char_id = qc.char_id
1787: AND qpc.enabled_flag = 1
1788: ORDER BY qpc.prompt_sequence;