DBA Data[Home] [Help]

APPS.OKC_RENEW_PUB dependencies on FND_USER

Line 373: is select fnd.user_name from okx_resources_v res, fnd_user fnd

369: --
370:
371:
372: CURSOR cur_user(p_user_id number)
373: is select fnd.user_name from okx_resources_v res, fnd_user fnd
374: where fnd.user_id=res.user_id and res.id1=p_user_id;
375:
376: l_ren_type okc_rules_v.rule_information1%type:=OKC_API.G_MISS_CHAR;
377: l_contact okc_rules_v.rule_information2%type:=OKC_API.G_MISS_CHAR;

Line 374: where fnd.user_id=res.user_id and res.id1=p_user_id;

370:
371:
372: CURSOR cur_user(p_user_id number)
373: is select fnd.user_name from okx_resources_v res, fnd_user fnd
374: where fnd.user_id=res.user_id and res.id1=p_user_id;
375:
376: l_ren_type okc_rules_v.rule_information1%type:=OKC_API.G_MISS_CHAR;
377: l_contact okc_rules_v.rule_information2%type:=OKC_API.G_MISS_CHAR;
378: