APPS.CS_ERES_INT_PKG dependencies on FND_USER

Line 677: , fnd_user fnd1

673: WHERE rs.resource_id = relSR.incident_owner_id
674: AND rs.language = userenv('LANG')) RelatedSR_Owner
675: FROM cs_incident_links SrLnkEO
676: , cs_sr_link_types_tl ltype
677: , fnd_user fnd1
678: , cs_incidents_all_b relSR
679: , cs_incidents_all_tl tlSR
680: , cs_incident_statuses_tl status
681: , cs_incident_severities_tl severity

Line 734: FND_USER fnd1

730: FND_LOOKUPS FLS ,
731: FND_LOOKUPS FLP,
732: jtf_rs_resource_extns ext_userb,
733: jtf_rs_resource_extns_tl ext_usert,
734: FND_USER fnd1
735: WHERE JNB.JTF_NOTE_ID = JNT.JTF_NOTE_ID
736: AND JNT.LANGUAGE = USERENV('LANG')
737: AND FLS.LOOKUP_TYPE(+) = 'JTF_NOTE_TYPE'
738: AND FLS.LOOKUP_CODE(+) = JNB.NOTE_TYPE

Line 1206: CURSOR Get_Fnd_User (v_user_id NUMBER) IS

1202: l_Sr_Creation_Channel_Name VARCHAR2(80);
1203: l_Customer_Type VARCHAR2(80);
1204:
1205: --:Created_By
1206: CURSOR Get_Fnd_User (v_user_id NUMBER) IS
1207: SELECT usr.user_name
1208: FROM fnd_user usr
1209: WHERE usr.user_id = v_user_id;
1210:

Line 1208: FROM fnd_user usr

1204:
1205: --:Created_By
1206: CURSOR Get_Fnd_User (v_user_id NUMBER) IS
1207: SELECT usr.user_name
1208: FROM fnd_user usr
1209: WHERE usr.user_id = v_user_id;
1210:
1211: l_Created_By VARCHAR2(100);
1212:

Line 1702: OPEN Get_Fnd_User (l_Created_By_Id);

1698: FETCH Get_Cs_Lookup INTO l_Sr_Creation_Channel_Name;
1699: CLOSE Get_Cs_Lookup;
1700:
1701:
1702: OPEN Get_Fnd_User (l_Created_By_Id);
1703: FETCH Get_Fnd_User INTO l_Created_By;
1704: CLOSE Get_Fnd_User;
1705:
1706: OPEN Get_Contact_Type(l_incident_id);

Line 1703: FETCH Get_Fnd_User INTO l_Created_By;

1699: CLOSE Get_Cs_Lookup;
1700:
1701:
1702: OPEN Get_Fnd_User (l_Created_By_Id);
1703: FETCH Get_Fnd_User INTO l_Created_By;
1704: CLOSE Get_Fnd_User;
1705:
1706: OPEN Get_Contact_Type(l_incident_id);
1707: FETCH Get_Contact_Type INTO l_Contact_Type;

Line 1704: CLOSE Get_Fnd_User;

1700:
1701:
1702: OPEN Get_Fnd_User (l_Created_By_Id);
1703: FETCH Get_Fnd_User INTO l_Created_By;
1704: CLOSE Get_Fnd_User;
1705:
1706: OPEN Get_Contact_Type(l_incident_id);
1707: FETCH Get_Contact_Type INTO l_Contact_Type;
1708: CLOSE Get_Contact_Type;