APPS.QA_WEB_TXN_API dependencies on QA_PLAN_TRANSACTIONS

Line 31: qa_plan_transactions qpt,

27: qpct.operator,
28: qpct.low_value,
29: qpct.high_value
30: FROM qa_plan_collection_triggers qpct,
31: qa_plan_transactions qpt,
32: qa_plans_val_v qp,
33: qa_chars qc,
34: qa_txn_collection_triggers qtct
35: WHERE qpt.plan_id = qp.plan_id

Line 170: qa_plan_transactions qpt,

166: qpct.operator,
167: qpct.low_value,
168: qpct.high_value
169: FROM qa_plan_collection_triggers qpct,
170: qa_plan_transactions qpt,
171: qa_plans qp,
172: qa_chars qc,
173: qa_txn_collection_triggers qtct
174: WHERE qp.plan_id = p_plan_id

Line 203: qa_plan_transactions qpt,

199: qpct.operator,
200: qpct.low_value,
201: qpct.high_value
202: FROM qa_plan_collection_triggers qpct,
203: qa_plan_transactions qpt,
204: qa_plans qp,
205: qa_chars qc
206: WHERE qp.plan_id = p_plan_id
207: and qpt.plan_id = qp.plan_id

Line 324: FROM qa_plan_transactions qpt

320: RETURN BOOLEAN IS
321:
322: CURSOR txn_plans IS
323: SELECT qpt.plan_id
324: FROM qa_plan_transactions qpt
325: WHERE qpt.plan_id = p_plan_id
326: AND qpt.transaction_number = p_txn_number;
327:
328: CURSOR txn_plans_for_asset IS

Line 330: FROM qa_plan_transactions qpt

326: AND qpt.transaction_number = p_txn_number;
327:
328: CURSOR txn_plans_for_asset IS
329: SELECT qpt.plan_id
330: FROM qa_plan_transactions qpt
331: WHERE qpt.plan_id = p_plan_id
332: AND qpt.transaction_number in (31, 32, 33);
333:
334: result BOOLEAN;

Line 426: FROM qa_plan_transactions

422: l_plan_type VARCHAR2(240) DEFAULT 'N/A';
423:
424: CURSOR c IS
425: SELECT decode(mandatory_collection_flag, 1, 'Mandatory', 2, 'Optional')
426: FROM qa_plan_transactions
427: WHERE plan_id = p_plan_id
428: AND transaction_number = p_txn_number
429: AND enabled_flag = 1;
430:

Line 456: FROM qa_plan_transactions

452: l_result VARCHAR2(1) DEFAULT 'N';
453:
454: CURSOR c IS
455: SELECT 'Y'
456: FROM qa_plan_transactions
457: WHERE plan_id = p_plan_id
458: AND transaction_number = p_txn_number
459: AND background_collection_flag = 1;
460:

Line 803: FROM qa_plan_transactions qpt, qa_plans qp

799: elements qa_txn_grp.ElementsArray;
800:
801: Cursor c1(txn_no number, org_id number, col_id number) is
802: SELECT DISTINCT qpt.plan_id
803: FROM qa_plan_transactions qpt, qa_plans qp
804: WHERE qpt.transaction_number = txn_no
805: AND qpt.plan_id = qp.plan_id
806: AND qp.organization_id = org_id
807: AND trunc(sysdate) between