APPS.CSI_ORG_UNIT_VLD_PVT dependencies on CSI_I_ORG_ASSIGNMENTS

Line 213: FROM csi_i_org_assignments_h s,

209:
210: IF p_end_date < sysdate THEN
211: SELECT MAX(t.transaction_date)
212: INTO l_transaction_date
213: FROM csi_i_org_assignments_h s,
214: csi_transactions t
215: WHERE s.instance_ou_id=p_instance_ou_id
216: AND s.transaction_id=t.transaction_id
217: AND t.transaction_id <> p_txn_id;

Line 352: FROM csi_i_org_assignments

348: END IF;
349: --
350: SELECT '1'
351: INTO l_dummy
352: FROM csi_i_org_assignments
353: WHERE instance_id = p_instance_id
354: -- AND operating_unit_id = p_operating_unit_id -- Fix for Bug # 3918188
355: AND instance_ou_id <> l_instance_ou_id
356: AND relationship_type_code = p_relationship_type_code;

Line 395: FROM csi_i_org_assignments

391: BEGIN
392: -- Verify that instance id is passed
393: SELECT '1'
394: INTO l_instance_ou_id
395: FROM csi_i_org_assignments
396: WHERE instance_ou_id = p_instance_ou_id;
397:
398: IF ( p_stack_err_msg = TRUE ) THEN
399: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INST_OU_ID');

Line 475: FROM csi_i_org_assignments

471: p_org_unit_rec.attribute13,
472: p_org_unit_rec.attribute14,
473: p_org_unit_rec.attribute15,
474: p_org_unit_rec.object_version_number
475: FROM csi_i_org_assignments
476: WHERE instance_ou_id = p_instance_ou_id;
477: RETURN TRUE;
478:
479:

Line 581: SELECT csi_i_org_assignments_s.nextval

577: RETURN NUMBER
578: IS
579: l_instance_ou_id NUMBER;
580: BEGIN
581: SELECT csi_i_org_assignments_s.nextval
582: INTO l_instance_ou_id
583: FROM dual;
584: RETURN l_instance_ou_id;
585: EXCEPTION

Line 608: SELECT csi_i_org_assignments_h_s.nextval

604: IS
605: l_cis_i_org_assign_h_id NUMBER;
606:
607: BEGIN
608: SELECT csi_i_org_assignments_h_s.nextval
609: INTO l_cis_i_org_assign_h_id
610: FROM dual;
611: RETURN l_cis_i_org_assign_h_id;
612: EXCEPTION