DBA Data[Home] [Help]

APPS.ZPB_WF dependencies on FND_USER

Line 523: FND_USER where user_id = usr_paused_BP_ID;

519: LAST_UPDATE_DATE = SYSDATE, LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
520: where instance_ac_id = INSTANCEID;
521:
522: select user_name into usr_paused_BP_Name from
523: FND_USER where user_id = usr_paused_BP_ID;
524:
525: resultout :='COMPLETE:PAUSED';
526: wf_engine.SetItemAttrText(
527: Itemtype => ItemType,

Line 3682: from fnd_user_resp_groups

3678:
3679: -- can also get RespId and RespAppId by simply selecting first ones found for owner of BP
3680: CURSOR c_respFromOwner is
3681: select /*+ FIRST_ROWS */ responsibility_id, responsibility_application_id
3682: from fnd_user_resp_groups
3683: where user_id=ownerID;
3684: v_respFromOwner c_respFromOwner%ROWTYPE;
3685:
3686:

Line 4140: from fnd_user_resp_groups

4136:
4137: -- can also get RespId and RespAppId by simply selecting first ones found for owner of BP
4138: CURSOR c_respFromOwner is
4139: select /*+ FIRST_ROWS */ responsibility_id, responsibility_application_id
4140: from fnd_user_resp_groups
4141: where user_id=ownerId;
4142: v_respFromOwner c_respFromOwner%ROWTYPE;
4143:
4144: begin