APPS.QA_WEB_TXN_API dependencies on QA_PLAN_TRANSACTIONS

Line 38: qa_plan_transactions qpt,

34: qpct.operator,
35: qpct.low_value,
36: qpct.high_value
37: FROM qa_plan_collection_triggers qpct,
38: qa_plan_transactions qpt,
39: qa_plans_val_v qp,
40: qa_chars qc,
41: qa_txn_collection_triggers qtct
42: WHERE qpt.plan_id = qp.plan_id

Line 177: qa_plan_transactions qpt,

173: qpct.operator,
174: qpct.low_value,
175: qpct.high_value
176: FROM qa_plan_collection_triggers qpct,
177: qa_plan_transactions qpt,
178: qa_plans qp,
179: qa_chars qc,
180: qa_txn_collection_triggers qtct
181: WHERE qp.plan_id = p_plan_id

Line 210: qa_plan_transactions qpt,

206: qpct.operator,
207: qpct.low_value,
208: qpct.high_value
209: FROM qa_plan_collection_triggers qpct,
210: qa_plan_transactions qpt,
211: qa_plans qp,
212: qa_chars qc
213: WHERE qp.plan_id = p_plan_id
214: and qpt.plan_id = qp.plan_id

Line 331: FROM qa_plan_transactions qpt

327: RETURN BOOLEAN IS
328:
329: CURSOR txn_plans IS
330: SELECT qpt.plan_id
331: FROM qa_plan_transactions qpt
332: WHERE qpt.plan_id = p_plan_id
333: AND qpt.transaction_number = p_txn_number;
334:
335: CURSOR txn_plans_for_asset IS

Line 337: FROM qa_plan_transactions qpt

333: AND qpt.transaction_number = p_txn_number;
334:
335: CURSOR txn_plans_for_asset IS
336: SELECT qpt.plan_id
337: FROM qa_plan_transactions qpt
338: WHERE qpt.plan_id = p_plan_id
339: AND qpt.transaction_number in (31, 32, 33);
340:
341: result BOOLEAN;

Line 433: FROM qa_plan_transactions

429: l_plan_type VARCHAR2(240) DEFAULT 'N/A';
430:
431: CURSOR c IS
432: SELECT decode(mandatory_collection_flag, 1, 'Mandatory', 2, 'Optional')
433: FROM qa_plan_transactions
434: WHERE plan_id = p_plan_id
435: AND transaction_number = p_txn_number
436: AND enabled_flag = 1;
437:

Line 463: FROM qa_plan_transactions

459: l_result VARCHAR2(1) DEFAULT 'N';
460:
461: CURSOR c IS
462: SELECT 'Y'
463: FROM qa_plan_transactions
464: WHERE plan_id = p_plan_id
465: AND transaction_number = p_txn_number
466: AND background_collection_flag = 1;
467:

Line 830: FROM qa_plan_transactions qpt, qa_plans qp

826: elements qa_txn_grp.ElementsArray;
827:
828: Cursor c1(txn_no number, org_id number, col_id number) is
829: SELECT DISTINCT qpt.plan_id
830: FROM qa_plan_transactions qpt, qa_plans qp
831: WHERE qpt.transaction_number = txn_no
832: AND qpt.plan_id = qp.plan_id
833: AND qp.organization_id = org_id
834: AND trunc(sysdate) between