DBA Data[Home] [Help]

APPS.CSI_PROCESS_TXN_PVT dependencies on CSI_I_ORG_ASSIGNMENTS

Line 2209: FROM csi_i_org_assignments

2205: SELECT instance_ou_id ,
2206: object_version_number
2207: INTO p_org_units_tbl(l_ind).instance_ou_id,
2208: p_org_units_tbl(l_ind).object_version_number
2209: FROM csi_i_org_assignments
2210: WHERE instance_id = p_instance_rec.instance_id
2211: AND relationship_type_code = p_org_units_tbl(l_ind).relationship_type_code
2212: AND operating_unit_id = p_org_units_tbl(l_ind).operating_unit_id
2213: AND sysdate BETWEEN nvl(active_start_date, sysdate-1)

Line 2290: FROM csi_i_org_assignments

2286: SELECT instance_ou_id,
2287: operating_unit_id,
2288: relationship_type_code,
2289: object_version_number
2290: FROM csi_i_org_assignments
2291: WHERE instance_id = p_instance_rec.instance_id
2292: AND sysdate BETWEEN nvl(active_start_date, sysdate-1)
2293: AND nvl(active_end_date, sysdate+1);
2294: l_nou_ind binary_integer;