DBA Data[Home] [Help]

APPS.OKC_TERMS_TMPL_APPROVAL_PVT dependencies on FND_USER

Line 1254: l_approver fnd_user.user_name%TYPE NULL;

1250: IS
1251:
1252: l_template_id NUMBER;
1253: l_tmpl_intent VARCHAR2(1);
1254: l_approver fnd_user.user_name%TYPE NULL;
1255: l_org_id NUMBER := NULL;
1256:
1257: CURSOR tmpl_approver_csr(cp_template_id IN NUMBER) IS
1258: SELECT decode(tmpl.intent,'S',org.org_information2,org.org_information6) org_information