APPS.CSC_ACTION_ASSEMBLER_PVT dependencies on CSC_CUST_PLANS

Line 16: from csc_cust_plans a,

12: IS
13: no_of_rows NUMBER := 0;
14: Cursor C1 IS
15: select a.plan_id
16: from csc_cust_plans a,
17: csc_plan_headers_b b
18: where a.party_id = p_Party_id
19: and a.plan_id = b.plan_id
20: and nvl(b.end_user_type, 'Y') = nvl(p_end_user_type, nvl(b.end_user_type, 'Y') )

Line 27: from csc_cust_plans a,

23: and trunc(sysdate) between trunc(nvl(b.start_date_active, sysdate))
24: and trunc(nvl(b.end_date_active, sysdate))
25: UNION
26: select a.plan_id
27: from csc_cust_plans a,
28: csc_plan_headers_b b
29: where a.party_id = p_party_id
30: and a.plan_id = b.plan_id
31: and nvl(b.end_user_type, 'Y') = nvl(p_end_user_type, nvl(b.end_user_type, 'Y') )