APPS.OKL_LEGAL_ENTITY_UTIL dependencies on XLE_ENTITY_PROFILES

Line 46: FROM XLE_ENTITY_PROFILES

42:
43: CURSOR get_le_name_csr(p_le_id IN NUMBER)
44: IS
45: SELECT name legal_entity_name
46: FROM XLE_ENTITY_PROFILES
47: WHERE legal_entity_id = p_le_id;
48:
49: l_legal_entity_name XLE_ENTITY_PROFILES.NAME%TYPE := NULL;
50:

Line 49: l_legal_entity_name XLE_ENTITY_PROFILES.NAME%TYPE := NULL;

45: SELECT name legal_entity_name
46: FROM XLE_ENTITY_PROFILES
47: WHERE legal_entity_id = p_le_id;
48:
49: l_legal_entity_name XLE_ENTITY_PROFILES.NAME%TYPE := NULL;
50:
51: BEGIN
52:
53: OPEN get_le_name_csr(p_le_id => p_legal_entity_id);

Line 70: l_legal_entity_id XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE := NULL;

66: SELECT khr.legal_entity_id
67: FROM okl_k_headers khr
68: WHERE khr.id = p_khr_id;
69:
70: l_legal_entity_id XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE := NULL;
71:
72: BEGIN
73: OPEN get_le_id_csr(p_khr_id => p_khr_id);
74: FETCH get_le_id_csr INTO l_legal_entity_id;

Line 92: l_legal_entity_id XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE := NULL;

88: WHERE khr.id = okc_ln.dnz_chr_id
89: -- AND okc_ln.chr_id =okc_ln.dnz_chr_id
90: AND okc_ln.id = p_kle_id1;
91:
92: l_legal_entity_id XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE := NULL;
93:
94: BEGIN
95: OPEN get_le_id_csr(p_kle_id);
96: FETCH get_le_id_csr INTO l_legal_entity_id;

Line 109: FROM XLE_ENTITY_PROFILES

105: IS
106: CURSOR get_le_id_csr(p_le_id1 IN NUMBER)
107: IS
108: SELECT 1
109: FROM XLE_ENTITY_PROFILES
110: WHERE legal_entity_id = p_le_id1;
111:
112: l_le_exist Number(1);
113: