APPS.CSI_INV_TRXS_PKG dependencies on FND_PROFILE

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

99:
100: cursor c_id is
101: SELECT instance_status_id
102: FROM csi_instance_statuses
103: WHERE name = FND_PROFILE.VALUE('CSI_DEFAULT_INSTANCE_STATUS');
104:
105: r_id c_id%rowtype;
106:
107: CURSOR c_obj_version (pc_instance_id IN NUMBER) is

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

1255:
1256: cursor c_id is
1257: SELECT instance_status_id
1258: FROM csi_instance_statuses
1259: WHERE name = FND_PROFILE.VALUE('CSI_DEFAULT_INSTANCE_STATUS');
1260:
1261: r_id c_id%rowtype;
1262:
1263: CURSOR c_obj_version (pc_instance_id IN NUMBER) is

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

2238: l_return_item VARCHAR2(1) := 'N';
2239: cursor c_id is
2240: SELECT instance_status_id
2241: FROM csi_instance_statuses
2242: WHERE name = FND_PROFILE.VALUE('CSI_DEFAULT_INSTANCE_STATUS');
2243:
2244: r_id c_id%rowtype;
2245:
2246: CURSOR c_phys_inv_info (pc_physical_adjustment_id IN NUMBER) is