APPS.CS_ERES_INT_PKG dependencies on FND_USER

Line 661: , fnd_user fnd1

657: WHERE rs.resource_id = relSR.incident_owner_id
658: AND rs.language = userenv('LANG')) RelatedSR_Owner
659: FROM cs_incident_links SrLnkEO
660: , cs_sr_link_types_tl ltype
661: , fnd_user fnd1
662: , cs_incidents_all_b relSR
663: , cs_incidents_all_tl tlSR
664: , cs_incident_statuses_tl status
665: , cs_incident_severities_tl severity

Line 712: FND_USER fnd1

708: FND_LOOKUPS FLS ,
709: FND_LOOKUPS FLP,
710: jtf_rs_resource_extns ext_userb,
711: jtf_rs_resource_extns_tl ext_usert,
712: FND_USER fnd1
713: WHERE JNB.JTF_NOTE_ID = JNT.JTF_NOTE_ID
714: AND JNT.LANGUAGE = USERENV('LANG')
715: AND FLS.LOOKUP_TYPE(+) = 'JTF_NOTE_TYPE'
716: AND FLS.LOOKUP_CODE(+) = JNB.NOTE_TYPE

Line 1135: CURSOR Get_Fnd_User (v_user_id NUMBER) IS

1131: l_Sr_Creation_Channel_Name VARCHAR2(80);
1132: l_Customer_Type VARCHAR2(80);
1133:
1134: --:Created_By
1135: CURSOR Get_Fnd_User (v_user_id NUMBER) IS
1136: SELECT usr.user_name
1137: FROM fnd_user usr
1138: WHERE usr.user_id = v_user_id;
1139:

Line 1137: FROM fnd_user usr

1133:
1134: --:Created_By
1135: CURSOR Get_Fnd_User (v_user_id NUMBER) IS
1136: SELECT usr.user_name
1137: FROM fnd_user usr
1138: WHERE usr.user_id = v_user_id;
1139:
1140: l_Created_By VARCHAR2(100);
1141:

Line 1617: OPEN Get_Fnd_User (l_Created_By_Id);

1613: FETCH Get_Cs_Lookup INTO l_Sr_Creation_Channel_Name;
1614: CLOSE Get_Cs_Lookup;
1615:
1616:
1617: OPEN Get_Fnd_User (l_Created_By_Id);
1618: FETCH Get_Fnd_User INTO l_Created_By;
1619: CLOSE Get_Fnd_User;
1620:
1621: OPEN Get_Contact_Type(l_incident_id);

Line 1618: FETCH Get_Fnd_User INTO l_Created_By;

1614: CLOSE Get_Cs_Lookup;
1615:
1616:
1617: OPEN Get_Fnd_User (l_Created_By_Id);
1618: FETCH Get_Fnd_User INTO l_Created_By;
1619: CLOSE Get_Fnd_User;
1620:
1621: OPEN Get_Contact_Type(l_incident_id);
1622: FETCH Get_Contact_Type INTO l_Contact_Type;

Line 1619: CLOSE Get_Fnd_User;

1615:
1616:
1617: OPEN Get_Fnd_User (l_Created_By_Id);
1618: FETCH Get_Fnd_User INTO l_Created_By;
1619: CLOSE Get_Fnd_User;
1620:
1621: OPEN Get_Contact_Type(l_incident_id);
1622: FETCH Get_Contact_Type INTO l_Contact_Type;
1623: CLOSE Get_Contact_Type;