DBA Data[Home] [Help]

APPS.QA_SS_CORE dependencies on QA_PLAN_TRANSACTIONS

Line 3431: qa_plan_transactions qpt,

3427: qpct.Operator,
3428: qpct.Low_Value,
3429: qpct.High_Value
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

Line 4167: FROM QA_PLAN_TRANSACTIONS QPT

4163: temp_plan_txn_id NUMBER := NULL;
4164: chk VARCHAR2(1);
4165: CURSOR plan_tx_cur IS
4166: SELECT qpt.plan_id, qpt.plan_transaction_id
4167: FROM QA_PLAN_TRANSACTIONS QPT
4168: Where qpt.plan_id = Pid
4169: and qpt.transaction_number = Txn_Num;
4170:
4171: --

Line 4291: FROM QA_PLAN_TRANSACTIONS QPT

4287: temp_pid NUMBER := NULL;
4288: chk VARCHAR2(1);
4289: CURSOR plan_tx_cur IS
4290: SELECT qpt.plan_id
4291: FROM QA_PLAN_TRANSACTIONS QPT
4292: Where qpt.plan_id = Pid
4293: and qpt.transaction_number = 100;
4294:
4295: BEGIN

Line 4382: FROM QA_PLAN_TRANSACTIONS QPT

4378: temp_pid NUMBER := NULL;
4379: chk VARCHAR2(1);
4380: CURSOR plan_tx_cur IS
4381: SELECT qpt.plan_id
4382: FROM QA_PLAN_TRANSACTIONS QPT
4383: Where qpt.plan_id = Pid
4384: and qpt.transaction_number = 110;
4385:
4386: BEGIN

Line 4441: qa_plan_transactions qpt,

4437: qpct.Operator,
4438: qpct.Low_Value,
4439: qpct.High_Value
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