APPS.OKC_AAE_PVT dependencies on OKC_ACTION_ATT_LOOKUPS_V

Line 618: FROM Okc_Action_Att_Lookups_V

614: CREATION_DATE,
615: LAST_UPDATED_BY,
616: LAST_UPDATE_DATE,
617: LAST_UPDATE_LOGIN
618: FROM Okc_Action_Att_Lookups_V
619: WHERE okc_action_att_lookups_v.id = p_id;
620: l_okc_aalv_pk okc_aalv_pk_csr%ROWTYPE;
621: CURSOR okc_acnv_pk_csr (p_id IN NUMBER) IS
622: SELECT

Line 619: WHERE okc_action_att_lookups_v.id = p_id;

615: LAST_UPDATED_BY,
616: LAST_UPDATE_DATE,
617: LAST_UPDATE_LOGIN
618: FROM Okc_Action_Att_Lookups_V
619: WHERE okc_action_att_lookups_v.id = p_id;
620: l_okc_aalv_pk okc_aalv_pk_csr%ROWTYPE;
621: CURSOR okc_acnv_pk_csr (p_id IN NUMBER) IS
622: SELECT
623: ID,

Line 1726: FROM Okc_Action_Att_Lookups_V

1722: l_dummy_var VARCHAR2(1);
1723:
1724: CURSOR okc_aalv_pk_csr (p_id IN NUMBER) IS
1725: SELECT '1'
1726: FROM Okc_Action_Att_Lookups_V
1727: WHERE okc_action_att_lookups_v.id = p_id;
1728:
1729: l_dummy VARCHAR2(1);
1730: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1727: WHERE okc_action_att_lookups_v.id = p_id;

1723:
1724: CURSOR okc_aalv_pk_csr (p_id IN NUMBER) IS
1725: SELECT '1'
1726: FROM Okc_Action_Att_Lookups_V
1727: WHERE okc_action_att_lookups_v.id = p_id;
1728:
1729: l_dummy VARCHAR2(1);
1730: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1731: l_row_notfound BOOLEAN := TRUE;