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 959: WHERE name = FND_PROFILE.VALUE('CSI_DEFAULT_INSTANCE_STATUS');

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

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

2346:
2347: cursor c_id is
2348: SELECT instance_status_id
2349: FROM csi_instance_statuses
2350: WHERE name = FND_PROFILE.VALUE('CSI_DEFAULT_INSTANCE_STATUS');
2351:
2352: r_id c_id%rowtype;
2353:
2354: cursor c_hz_loc (pc_location_id IN NUMBER) is