APPS.CSI_INV_ISO_PKG dependencies on FND_PROFILE

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

95:
96: cursor c_id is
97: SELECT instance_status_id
98: FROM csi_instance_statuses
99: WHERE name = FND_PROFILE.VALUE('CSI_DEFAULT_INSTANCE_STATUS');
100:
101: r_id c_id%rowtype;
102:
103: cursor c_inst (pc_instance_id in NUMBER) is

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

2103:
2104: cursor c_id is
2105: SELECT instance_status_id
2106: FROM csi_instance_statuses
2107: WHERE name = FND_PROFILE.VALUE('CSI_DEFAULT_INSTANCE_STATUS');
2108:
2109: r_id c_id%rowtype;
2110:
2111: CURSOR c_item_control (pc_item_id in number,

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

4121:
4122: cursor c_id is
4123: SELECT instance_status_id
4124: FROM csi_instance_statuses
4125: WHERE name = FND_PROFILE.VALUE('CSI_DEFAULT_INSTANCE_STATUS');
4126:
4127: r_id c_id%rowtype;
4128:
4129: -- Get the Transaction ID for the (-) quantity transaction and pass that