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));
167: BEGIN
168: OPEN c1;

Line 372: csi_item_instances cii

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

Line 460: FROM csi_item_instances

456:
457: CURSOR c1 IS
458: SELECT active_start_date,
459: active_end_date
460: FROM csi_item_instances
461: WHERE instance_id = p_instance_id
462: and ((active_end_date is null) OR (active_end_date >= sysdate));
463: BEGIN
464: IF ((p_end_date is NOT NULL) AND (p_end_date <> FND_API.G_MISS_DATE))THEN

Line 521: FROM csi_item_instances

517:
518: CURSOR c1 IS
519: SELECT active_end_date,
520: active_start_date
521: FROM csi_item_instances
522: WHERE instance_id = p_instance_id
523: and ((active_end_date is null) OR (active_end_date >= sysdate));
524: BEGIN
525: IF p_end_date is NOT NULL THEN

Line 578: FROM csi_item_instances

574:
575: CURSOR c1 IS
576: SELECT active_end_date,
577: active_start_date
578: FROM csi_item_instances
579: WHERE instance_id = p_instance_id
580: and ((active_end_date is null) OR (active_end_date >= sysdate));
581: BEGIN
582:

Line 824: FROM csi_item_instances

820: l_return_value BOOLEAN := TRUE;
821: BEGIN
822: SELECT 'x'
823: INTO l_dummy
824: FROM csi_item_instances
825: WHERE instance_id = p_Instance_id
826: AND ((active_end_date is null) OR (active_end_date >= sysdate))
827: AND creation_complete_flag = 'Y';
828: RETURN l_return_value;

Line 1398: FROM csi_item_instances

1394:
1395: CURSOR c1 IS
1396: SELECT active_start_date,
1397: active_end_date
1398: FROM csi_item_instances
1399: WHERE instance_id = p_instance_id
1400: and ((active_end_date is null) OR (active_end_date >= sysdate));
1401: BEGIN
1402: OPEN c1;