APPS.CSI_INSTANCE_PARTIES_VLD_PVT dependencies on CSI_ITEM_INSTANCES

Line 164: FROM csi_item_instances

160: l_return_value BOOLEAN := TRUE;
161:
162: CURSOR c1 IS
163: SELECT 'x'
164: FROM csi_item_instances
165: WHERE instance_id = p_instance_id
166: --and ((active_end_date is null) OR (active_end_date >= sysdate)); commented Bug 8768694
167: and ((active_end_date is null) OR (trunc(active_end_date,'MI') >= trunc(SYSDATE,'MI'))); --Changed to trunc for bug 9750206
168:

Line 374: csi_item_instances cii

370: CURSOR C1( i_inst_party_id IN NUMBER)IS
371: SELECT cip.party_id,
372: cip.party_source_table
373: FROM csi_i_parties cip,
374: csi_item_instances cii
375: WHERE cip.instance_party_id = i_inst_party_id
376: AND cip.instance_id = cii.instance_id
377: AND ((cip.active_end_date IS NULL) OR (cip.active_end_date >= SYSDATE));
378:

Line 462: FROM csi_item_instances

458:
459: CURSOR c1 IS
460: SELECT active_start_date,
461: active_end_date
462: FROM csi_item_instances
463: WHERE instance_id = p_instance_id
464: and ((active_end_date is null) OR (trunc(active_end_date,'MI') >= trunc(SYSDATE,'MI'))); --Changed to trunc for bug 9750206
465: BEGIN
466: IF ((p_end_date is NOT NULL) AND (p_end_date <> FND_API.G_MISS_DATE))THEN

Line 523: FROM csi_item_instances

519:
520: CURSOR c1 IS
521: SELECT active_end_date,
522: active_start_date
523: FROM csi_item_instances
524: WHERE instance_id = p_instance_id
525: and ((active_end_date is null) OR (to_date(active_end_date,'DD-MM-YY HH24:MI') >= to_date(sysdate,'DD-MM-YY HH24:MI')));
526: BEGIN
527: IF p_end_date is NOT NULL THEN

Line 580: FROM csi_item_instances

576:
577: CURSOR c1 IS
578: SELECT active_end_date,
579: active_start_date
580: FROM csi_item_instances
581: WHERE instance_id = p_instance_id
582: and ((active_end_date is null) OR (trunc(active_end_date,'MI') >= trunc(sysdate,'MI'))); --Changed to trunc for bug 9750206
583: BEGIN
584:

Line 826: FROM csi_item_instances

822: l_return_value BOOLEAN := TRUE;
823: BEGIN
824: SELECT 'x'
825: INTO l_dummy
826: FROM csi_item_instances
827: WHERE instance_id = p_Instance_id
828: AND ((active_end_date is null) OR (trunc(active_end_date,'MI') >= trunc(sysdate,'MI'))) --Changed to trunc for bug 9750206
829: AND creation_complete_flag = 'Y';
830: RETURN l_return_value;

Line 1402: FROM csi_item_instances

1398:
1399: CURSOR c1 IS
1400: SELECT active_start_date,
1401: active_end_date
1402: FROM csi_item_instances
1403: WHERE instance_id = p_instance_id
1404: and ((active_end_date is null) OR (trunc(active_end_date,'MI') >= trunc(sysdate,'MI'))); --Changed to trunc for bug 9750206
1405: BEGIN
1406: OPEN c1;