DBA Data[Home] [Help]

APPS.OKC_TERMS_TMPL_APPROVAL_PVT dependencies on FND_USER

Line 1205: l_approver fnd_user.user_name%TYPE NULL;

1201: IS
1202:
1203: l_template_id NUMBER;
1204: l_tmpl_intent VARCHAR2(1);
1205: l_approver fnd_user.user_name%TYPE NULL;
1206: l_org_id NUMBER := NULL;
1207:
1208: CURSOR tmpl_approver_csr(cp_template_id IN NUMBER) IS
1209: SELECT decode(tmpl.intent,'S',org.org_information2,org.org_information6) org_information