DBA Data[Home] [Help]

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

1228:
1229: cursor c_id is
1230: SELECT instance_status_id
1231: FROM csi_instance_statuses
1232: WHERE name = FND_PROFILE.VALUE('CSI_DEFAULT_INSTANCE_STATUS');
1233:
1234: r_id c_id%rowtype;
1235:
1236: CURSOR c_obj_version (pc_instance_id IN NUMBER) is

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

2184:
2185: cursor c_id is
2186: SELECT instance_status_id
2187: FROM csi_instance_statuses
2188: WHERE name = FND_PROFILE.VALUE('CSI_DEFAULT_INSTANCE_STATUS');
2189:
2190: r_id c_id%rowtype;
2191:
2192: CURSOR c_phys_inv_info (pc_physical_adjustment_id IN NUMBER) is