APPS.OKC_REP_WF_PVT dependencies on FND_USER

Line 792: l_recipient_name FND_USER.user_name%type;

788: l_contract_version OKC_REP_CON_APPROVALS.contract_version_num%type;
789: l_approver_record2 ame_util.approverRecord2;
790: l_approver_id number;
791: l_approval_status VARCHAR2(30);
792: l_recipient_name FND_USER.user_name%type;
793: l_action_code OKC_REP_CON_APPROVALS.action_code%type;
794: l_wf_note VARCHAR2(2000);
795: l_api_name VARCHAR2(30);
796: l_return_status VARCHAR2(1);

Line 811: FROM fnd_user fu, wf_notifications wfn, fnd_user fu1

807:
808: CURSOR notif_csr (p_notification_id NUMBER) IS
809: SELECT fu.user_id user_id, fu.user_name user_name,
810: fu1.user_id original_user_id,fu1.user_name original_user_name
811: FROM fnd_user fu, wf_notifications wfn, fnd_user fu1
812: WHERE fu.user_name = wfn.recipient_role
813: AND fu1.user_name = wfn.original_recipient
814: AND wfn.notification_id = p_notification_id ;
815:

Line 1107: l_recipient_name FND_USER.user_name%type;

1103: l_approver_record2 ame_util.approverRecord2;
1104: l_notification_record ame_util2.notificationRecord;
1105: l_approver_id number;
1106: l_approval_status VARCHAR2(30);
1107: l_recipient_name FND_USER.user_name%type;
1108: l_action_code OKC_REP_CON_APPROVALS.action_code%type;
1109: l_wf_note VARCHAR2(2000);
1110: l_api_name VARCHAR2(30);
1111: l_return_status VARCHAR2(1);

Line 1126: FROM fnd_user fu, wf_notifications wfn, fnd_user fu1

1122:
1123: CURSOR notif_csr (p_notification_id NUMBER) IS
1124: SELECT fu.user_id user_id, fu.user_name user_name,
1125: fu1.user_id original_user_id,fu1.user_name original_user_name
1126: FROM fnd_user fu, wf_notifications wfn, fnd_user fu1
1127: WHERE fu.user_name = wfn.recipient_role
1128: AND fu1.user_name = wfn.original_recipient
1129: AND wfn.notification_id = p_notification_id ;
1130: