APPS.OKC_EXP_DATE_ASMBLR_PVT dependencies on OKC_ACTIONS_B

Line 109: SELECT acn.id INTO l_acn_id FROM okc_actions_b acn

105: /* SELECT acn.correlation INTO l_corrid_rec FROM okc_actions_v acn
106: WHERE acn.correlation = 'KEXPIRE';*/
107:
108: --Get the action id
109: SELECT acn.id INTO l_acn_id FROM okc_actions_b acn
110: WHERE acn.correlation = 'KEXPIRE';
111:
112: --Check if the variance is positive or negative
113: IF p_before_after = 'A' THEN

Line 384: SELECT acn.id INTO l_acn_id FROM okc_actions_b acn

380: --Get the correlation
381: /*SELECT acn.correlation INTO l_corrid_rec FROM okc_actions_v acn
382: WHERE acn.correlation = 'KLEXPIRE';*/
383: --Get the action id
384: SELECT acn.id INTO l_acn_id FROM okc_actions_b acn
385: WHERE acn.correlation = 'KLEXPIRE';
386:
387: IF (l_debug = 'Y') THEN
388: okc_debug.Log('120: After fetching into l_corrid_rec ',2);