DBA Data[Home] [Help]

APPS.OKS_COVERAGES_PVT dependencies on OKC_CONDITION_OCCURS_V

Line 3218: SELECT id FROM OKC_Condition_Occurs_v where Cnh_Id=P_Cnh_Id;

3214: CURSOR Cur_Cnh(P_KLine_Id IN NUMBER) IS
3215: SELECT id FROM OKC_Condition_Headers_v where Object_Id=P_KLine_Id
3216: and JTOT_Object_Code='OKC_K_LINE';
3217: CURSOR Cur_Coe (P_Cnh_Id IN NUMBER) IS
3218: SELECT id FROM OKC_Condition_Occurs_v where Cnh_Id=P_Cnh_Id;
3219: CURSOR Cur_aav (P_Coe_Id IN NUMBER) IS
3220: SELECT aae_Id,coe_id FROM Okc_Action_att_vals_v WHERE coe_id=P_Coe_Id;
3221: CURSOR Cur_Cnl (P_Cnh_Id IN NUMBER) IS
3222: SELECT id FROM OKC_Condition_Lines_v WHERE Cnh_Id = P_Cnh_Id;