DBA Data[Home] [Help]

APPS.OKS_COVERAGES_PVT dependencies on OKC_ACTION_ATT_VALS_V

Line 3220: SELECT aae_Id,coe_id FROM Okc_Action_att_vals_v WHERE coe_id=P_Coe_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;
3223: CURSOR Cur_oce (P_Cnh_Id IN NUMBER) IS
3224: SELECT id FROM OKC_OUTCOMES_V WHERE cnh_Id=P_Cnh_Id;