DBA Data[Home] [Help]

APPS.OKL_OKC_MIGRATION_PVT dependencies on OKC_CONTACTS

Line 13: --9.OKC_CONTACTS_V -- ctcv

9: --5.OKC_K_PARTY_ROLES_V -- cplv
10: --6.OKC_GOVERNANCES_V -- gvev
11: --7.OKC_RULE_GROUPS_V -- rgpv
12: --8.OKC_RG_PARTY_ROLES_V -- rmpv
13: --9.OKC_CONTACTS_V -- ctcv
14: -- End of Listing
15: -- Badriath Kuchibhotla
16: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_OKC_MIGRATION_PVT';
17:

Line 2748: FROM OKC_CONTACTS

2744:
2745: --cursor to find out chr id required to flip status at edit point
2746: CURSOR chr_id_crs (p_ctc_id IN NUMBER) IS
2747: SELECT DNZ_CHR_ID
2748: FROM OKC_CONTACTS
2749: WHERE ID = P_CTC_ID;
2750:
2751: l_dnz_chr_id OKC_CONTACTS.dnz_chr_id%TYPE;
2752:

Line 2751: l_dnz_chr_id OKC_CONTACTS.dnz_chr_id%TYPE;

2747: SELECT DNZ_CHR_ID
2748: FROM OKC_CONTACTS
2749: WHERE ID = P_CTC_ID;
2750:
2751: l_dnz_chr_id OKC_CONTACTS.dnz_chr_id%TYPE;
2752:
2753: BEGIN
2754: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2755: -- Call start_activity to create savepoint, check compatibility