APPS.CSI_INV_HZ_PKG dependencies on FND_PROFILE

Line 84: WHERE name = FND_PROFILE.VALUE('CSI_DEFAULT_INSTANCE_STATUS');

80:
81: cursor c_id is
82: SELECT instance_status_id
83: FROM csi_instance_statuses
84: WHERE name = FND_PROFILE.VALUE('CSI_DEFAULT_INSTANCE_STATUS');
85:
86: r_id c_id%rowtype;
87:
88: cursor c_hz_loc (pc_location_id IN NUMBER) is

Line 956: WHERE name = FND_PROFILE.VALUE('CSI_DEFAULT_INSTANCE_STATUS');

952:
953: cursor c_id is
954: SELECT instance_status_id
955: FROM csi_instance_statuses
956: WHERE name = FND_PROFILE.VALUE('CSI_DEFAULT_INSTANCE_STATUS');
957:
958: r_id c_id%rowtype;
959:
960: cursor c_hz_loc (pc_location_id IN NUMBER) is

Line 2275: WHERE name = FND_PROFILE.VALUE('CSI_DEFAULT_INSTANCE_STATUS');

2271:
2272: cursor c_id is
2273: SELECT instance_status_id
2274: FROM csi_instance_statuses
2275: WHERE name = FND_PROFILE.VALUE('CSI_DEFAULT_INSTANCE_STATUS');
2276:
2277: r_id c_id%rowtype;
2278:
2279: cursor c_hz_loc (pc_location_id IN NUMBER) is