DBA Data[Home] [Help]

APPS.QLTAUFLB dependencies on QA_CHARS

Line 90: qa_chars qc

86: qpc.attribute15,
87: qpc.default_value_id
88: FROM
89: qa_plan_chars qpc,
90: qa_chars qc
91: WHERE
92: qpc.plan_id = p_from_plan_id AND
93: qpc.char_id IN (
94: SELECT id

Line 1134: FROM qa_chars

1130: -- elements Asset Group and Asset Number.
1131:
1132: CURSOR element_cur IS
1133: SELECT char_id,prompt,hardcoded_column
1134: FROM qa_chars
1135: WHERE char_id IN (l_asset_group_char_id,l_asset_number_char_id);
1136:
1137: BEGIN
1138: -- finding out the max value of the prompt

Line 1217: FROM qa_chars

1213: -- Cursor to find the hardcoded values of the LPN
1214:
1215: CURSOR lpn_cur IS
1216: SELECT char_id cid,prompt pro,hardcoded_column hc
1217: FROM qa_chars
1218: WHERE char_id = 150;
1219:
1220: PROMPT_SEQ NUMBER;
1221: LPN_REC lpn_cur%ROWTYPE;

Line 1287: FROM qa_chars

1283:
1284: CURSOR eam_cur IS
1285: SELECT char_id cid,prompt pro,hardcoded_column hc,enabled_flag,
1286: mandatory_flag
1287: FROM qa_chars
1288: WHERE char_id in (SELECT char_id
1289: FROM
1290: qa_plan_chars qpc1
1291: WHERE plan_id=X_COPY_PLAN_ID