APPS.QA_SS_CORE dependencies on QA_TXN_COLLECTION_TRIGGERS

Line 1326: From qa_txn_collection_triggers qtct

1322: coll_seed_ex EXCEPTION;
1323: BEGIN
1324:
1325: Select count(1) INTO coll_trigg
1326: From qa_txn_collection_triggers qtct
1327: WHERE qtct.transaction_number = txnumber
1328: AND qtct.collection_trigger_id = cid;
1329:
1330: IF (coll_trigg = 1) Then

Line 3434: qa_txn_collection_triggers qtct

3430: FROM qa_plan_collection_triggers qpct,
3431: qa_plan_transactions qpt,
3432: qa_plans_val_v qp,
3433: qa_chars qc,
3434: qa_txn_collection_triggers qtct
3435: WHERE qpt.Plan_ID = qp.Plan_ID
3436: AND qpct.Plan_Transaction_ID(+) = qpt.Plan_Transaction_ID
3437: AND qpct.Collection_Trigger_ID = qtct.Collection_Trigger_ID(+)
3438: AND qpct.Collection_Trigger_ID = qc.char_id(+)

Line 4444: qa_txn_collection_triggers qtct

4440: FROM qa_plan_collection_triggers qpct,
4441: qa_plan_transactions qpt,
4442: qa_plans qp,
4443: qa_chars qc,
4444: qa_txn_collection_triggers qtct
4445: WHERE qp.Plan_ID = x_Pid
4446: AND qpt.Plan_ID = qp.Plan_ID
4447: AND qpct.Plan_Transaction_ID(+) = qpt.Plan_Transaction_ID
4448: AND qpct.Collection_Trigger_ID = qtct.Collection_Trigger_ID(+)

Line 4620: FROM qa_txn_collection_triggers qtct

4616: dummy NUMBER;
4617:
4618: CURSOR c IS
4619: SELECT 1
4620: FROM qa_txn_collection_triggers qtct
4621: WHERE qtct.transaction_number = txn_number
4622: AND qtct.collection_trigger_id = element_id;
4623:
4624: BEGIN