DBA Data[Home] [Help]

APPS.AHL_PRD_DISPOSITION_PVT dependencies on QA_PLAN_TRANSACTIONS_V

Line 1647: select 'x' from qa_plan_transactions_v

1643: l_rel_nm_wo_id NUMBER;
1644: l_primary_sr_created BOOLEAN := FALSE;
1645:
1646: cursor is_qa_coll_reqd(p_plan_id IN NUMBER) IS
1647: select 'x' from qa_plan_transactions_v
1648: where mandatory_collection_flag = 1 and enabled_flag = 1
1649: and plan_id = p_plan_id;
1650:
1651: BEGIN

Line 3408: select 'x' from qa_plan_transactions_v

3404: l_dummy VARCHAR2(1);
3405: l_srl_flag VARCHAR2(1) := 'Y';
3406:
3407: cursor is_qa_coll_reqd(p_plan_id IN NUMBER) IS
3408: select 'x' from qa_plan_transactions_v
3409: where mandatory_collection_flag = 1 and enabled_flag = 1
3410: and plan_id = p_plan_id;
3411:
3412: BEGIN